Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative counts Of Assets

Hi Filks, Can anyone help me on below two scenarios to write DAX. 1. If RFID is A then cumulative count of Asset(Last Second column) should display is 1, if it's repeats A is 2, A is 3. If it return...
Data Protection
Show and Tell
Tutorial Requests
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    Please refer to my .pbix file. But I don't quite understand the logic of the second formula. Please give me an example.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Typically cumm with help date table

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('date'),'date'[date] <=max('date'[date])))

 

or same table 

Cumm Sales = CALCULATE(SUM('Sales'[Sales Amount]),filter(allselected('Sales'),'Sales'[date] <=max('Sales'[date])))

 

Appreciate your Kudos.