Cumulative counts Of Assets

[Anonymous]

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 returns B then it will display like 1, C is 1,  D is 1. If it all repeats then the number will be changed.

2. If RFID is A comes under with in planned start date and Planned end date then its display as 1, if its repeats also the vale is 1. If RFID comes out under with in planned start date and end date then its retun as 2.

Please help me Dax.

 

[v-lionel-msft · Accepted solution]

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]

@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.