Forum Discussion
Whitewater100
Solution Sage
Solution SageMeasure for Index Starting at One Based on Slicer Selection
Hello PBI Community: I am looking for assistance to evelope a measure that would have an index column in a table visual, always start with one, based on a slicer selection. I have provided a samp...
Hi ThxAlot: That worked fantastic on my example. Thank you very much. I'll accept as the solution.
What is strange is when I apply the measure to my real data it counts the total number of ID's. Maybe I can try reproducing a table similiar to what I have. But you solved what was asked. Thank you!
ThxAlot
Super User
Super UserIdx =
CALCULATE(
DISTINCTCOUNT( 'Table'[ID] ),
'Table'[index] <= MAX( 'Table'[Index] ),
ALLSELECTED()
)
Whitewater100Hi ThxAlot: That worked fantastic on my example. Thank you very much. I'll accept as the solution.
What is strange is when I apply the measure to my real data it counts the total number of ID's. Maybe I can try reproducing a table similiar to what I have. But you solved what was asked. Thank you!