Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Whitewater100
Solution Sage
Solution Sage

Measure 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 sample file and desired results. Thank in advance for any input on this measure. 

Please see attached. Thank you!https://drive.google.com/file/d/1nqTERC3Hdhng7vxtvlhXgmCdJT40rSFU/view?usp=share_link 

1 ACCEPTED SOLUTION

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!

View solution in original post

2 REPLIES 2
ThxAlot
Super User
Super User

Idx = 
CALCULATE(
    DISTINCTCOUNT( 'Table'[ID] ),
    'Table'[index] <= MAX( 'Table'[Index] ),
    ALLSELECTED()
)

ThxAlot_0-1682801709106.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors