Forum Discussion

Icon for Resolver II rank

Resolver II

5 years ago

Solved

Dax Running Total matrix

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

5 years ago

pls try this

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

runningtotal.pbix36 KB

RENJITH_R_S
5 years ago
ryan_mayu Thanks

Icon for Super User rank

Super User

5 years ago

pls try this

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

runningtotal.pbix36 KB

RENJITH_R_S
Resolver II
5 years ago
ryan_mayu Thanks
- ryan_mayu
  Super User
  5 years ago
  you are welcome
  - RENJITH_R_S
    Resolver II
    5 years ago
    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