Forum Discussion
Measure for dividing rows within the same column
Anonymous ,
To be general, suppose the table is like below.
You may try these steps, firstly, click Modeling-> New Table and create a summarized table using DAX below(You should add a rank column as index).
Table = ADDCOLUMNS(VALUES(Table1[Data]), "Rank", RANKX(VALUES(Table1[Data]), Table1[Data], , ASC, Dense))
Then create another table which contains selection value and create a slicer based on that column, finally create a measure in 'Table' using DAX below and drag the measure to a card visual.
You may also refer to the appendix.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportAnonymous ,
To be general, suppose the table is like below.
You may try these steps, firstly, click Modeling-> New Table and create a summarized table using DAX below(You should add a rank column as index).
Table = ADDCOLUMNS(VALUES(Table1[Data]), "Rank", RANKX(VALUES(Table1[Data]), Table1[Data], , ASC, Dense))
Then create another table which contains selection value and create a slicer based on that column, finally create a measure in 'Table' using DAX below and drag the measure to a card visual.
You may also refer to the appendix.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.