Measure for dividing rows within the same column

[Anonymous]

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

[v-yuta-msft · Accepted solution]

@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.