Forum Discussion
Measure for dividing rows within the same column
Hi
Hoping for a little assistance on this one.
I have a column with aprox 100.000 rows and 3 different values inside it.
I need a measure (or another way) of dividing these values against eachother to give me the percentage difference between them.
I have not been able to get it to work.
Will appriciate all suggestions
Thanks
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.
1 Reply
v-yuta-msftCommunity Support
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.