Forum Discussion

leandroduarte's avatar
leandroduarte
Helper I
7 years ago
Solved

Create a Index comparison based on first row selected

Dear Colleagues, I'm looking for a simple solution to use the DAX measures to get the index based on the first value.   The example is below with the Index value targeted as results. It needs to ch...
Tips and Tricks
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, leandroduarte 

First, you should know that calculated column and calculate table can't be affected by any slicer. you could create a measure instead of column.
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

 

Then you could use RANKX Function to create a measure

Measure = RANKX(ALLSELECTED(Table1),CALCULATE(SUM(Table1[Amount])),,ASC,Dense)

Result:

Best Regards,

Lin