Forum Discussion

xichiza's avatar
xichiza
Frequent Visitor
5 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
    5 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]))

     

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
5 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]))