Dax Running Total matrix

[RENJITH_R_S]

Friends, Can u help me to write the dax code for running total matrix.See my requirement

[ryan_mayu · Accepted solution]

@RENJITH_R_S 

pls try this

Measure = calculate(COUNTROWS('Table'),FILTER(all('Table'),'Table'[Date]<=max('Table'[Date])&&'Table'[Status]=max('Table'[Status])))

[ryan_mayu · Accepted solution]

@RENJITH_R_S 

pls try this

Measure = calculate(COUNTROWS('Table'),FILTER(all('Table'),'Table'[Date]<=max('Table'[Date])&&'Table'[Status]=max('Table'[Status])))

[RENJITH_R_S · Accepted solution]

@ryan_mayu Thanks

[ryan_mayu]

you are welcome

[RENJITH_R_S]

@ryan_mayu , How we can implement this running total is no data available on a particular month

for eg Jan 5 feb no data available and march 5, so running total of march will be 10

[ryan_mayu]

@RENJITH_R_S 

I tried some ways , but all failed. I am also interested in this topic. So I rasied a similar post for searching the solutions.

https://community.powerbi.com/t5/Desktop/Running-total/m-p/2022833#M759984

Two experts provided the solutions.

Thanks for asking the further question and I also learned a lot.