Forum Discussion

xichiza's avatar
xichiza
Frequent Visitor
4 years ago
Solved

HELP - Cumulative count for latest value (string)

Hi Everyone,   I am struggling with a issue even if I feel like it is not that complicated. I need to get the cumulative count of latest grade for employees.   January : If employee A gets Grade ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Please try to create three similar measures.

    Total A = CALCULATE(COUNTX(FILTER(ALLSELECTED('Table'),'Table'[Month]<=MAX('Table'[Month])&&'Table'[Grade]="A"),'Table'[Employee]))

     

xichiza's avatar
xichiza
Frequent Visitor
4 years ago

amitchandak any update on your end ? Don't know if it is understable .. Let me know ! thanks