Group by the value of a measure

[Syndicate_Admin]

Good day, I have the next doubt.

Perform the following measurements to be able to calculate some materials with greater amount of use, through ranges, in which you calculate a ranking, and a cumulative percentage (ranges)

Before you can filter, use the following measure:

How can I calculate the lines with this measurement and filter applied? For example if filter by ranges to 8% throws me 3 lines, but I do not know how to reflect that value on a card, that is, how do I group by the value of a measure?

[Icey]

Hi @pauiglesias ,

Please try this:

Filter Measure =
SWITCH ( [Total Acumulado OS] <= SELECTEDVALUE ( 'Rango OS'[Rango] ), 1, 0 )

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , replace var total

by

calculate(sum( consumo[candid OS]) , filter(allselected(consumo) , consumo[model] =max(consumo[model]) && consumo[series] =max(consumo[series])) )

and try