Forum Discussion
FUNCTION SUBTOTALS
Regards,
I'm new to Dax, what function can I use to comply with what the SUBTOTAL function does in Excel? In the example I show, it will always show me from 1 to N (column N) according to the filter that is done in column M. Thanks for the help
Hi Anonymous ,
To create two measures as below to get the excepted result we need.
_sum = CALCULATE(SUM(Table1[POSICION SIN REPERTIR]))
_rank = RANKX(ALLSELECTED(Table1),[_sum],,DESC,Dense)
Pbix as attached.
Regards,
Frank
2 Replies
Hi Anonymous ,
To create two measures as below to get the excepted result we need.
_sum = CALCULATE(SUM(Table1[POSICION SIN REPERTIR]))
_rank = RANKX(ALLSELECTED(Table1),[_sum],,DESC,Dense)
Pbix as attached.
Regards,
Frank
Greetings v-frfei-msft,
Excellent !!, I made your suggestion and it was perfect! Looking at the result I would like to do something:
Maybe if I could use a visual object with this new measure that would allow me to filter two, three or 10 or N elements of the table. Something like this: (I put the field "Position without repeating" as an example, but the idea is to use the "Range" field)
(What I'm noticing is that these visual objects do not work with calculated measurements (correct me if I'm wrong.) Very, very grateful, with your help, I'll be like a king in my area.