Count number of times remaining a value shows in a column

[Anonymous]

Hi, I have this measure:

Measure 3 = CALCULATE(COUNT('Hours Data'[Full Name]), ALLEXCEPT('Hours Data', 'Hours Data'[Full Name]), GROUPBY('Hours Data', 'Hours Data'[Department Full Path]))

 And it produces this output in a table:

What I am hoping to achieve is for Measure 3 to show a decreasing count of how many records are left in the table, rather than a total count.  For example, it would start at 22 then 21, 20, 19, etc...

I greatly appreciate any help.

Thanks,

[Fowmy · Accepted solution]

@Anonymous 

Can you try this measure, hope it meets your requirement.

Measure 3 = 

VAR I = MAX('Hours Data'[Index]) 
RETURN
CALCULATE(
    COUNTROWS('Hours Data'),
    'Hours Data'[Index] >= I,
    ALLEXCEPT('Hours Data','Hours Data'[Path Full Name])
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

@Fowmy Thank you so much! Worked perfectly! Marked as the solution.