Forum Discussion

RY2019's avatar
RY2019
Frequent Visitor
4 years ago
Solved

Cumulative Total in Matrix

Hi all,

 

does somebody know how I can adjust or cumulativ a secific column in a Matrix visualization ?

 

How I want to see it in my Power BI Report you can see it in the screenshot in green:

 

What Dax Formula I can take to get my cumulativ Total with rd. 9mio.

 

Thanks in Advance for any ideas :).



  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    All measures are in the attached pbix file.

     

     

    Cumulative: =
    SUMX (
    VALUES ( Database[Stage] ),
    CALCULATE (
    CALCULATE (
    SUM ( Database[Baseline] ),
    FILTER ( ALL ( Database ), Database[Stage] <= MAX ( Database[Stage] ) )
    )
    )
    )
     
    Want to see: =
    IF (
    HASONEVALUE ( Database[Stage] ),
    CALCULATE (
    [Cumulative:],
    FILTER ( ALL ( Database ), Database[Stage] <= MAX ( Database[Stage] ) )
    )
    )
     

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    4 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    All measures are in the attached pbix file.

     

     

    Cumulative: =
    SUMX (
    VALUES ( Database[Stage] ),
    CALCULATE (
    CALCULATE (
    SUM ( Database[Baseline] ),
    FILTER ( ALL ( Database ), Database[Stage] <= MAX ( Database[Stage] ) )
    )
    )
    )
     
    Want to see: =
    IF (
    HASONEVALUE ( Database[Stage] ),
    CALCULATE (
    [Cumulative:],
    FILTER ( ALL ( Database ), Database[Stage] <= MAX ( Database[Stage] ) )
    )
    )
     
  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    Just to be clear, you want a cumulative total of a cumulative total column?

    • RY2019's avatar
      RY2019
      Frequent Visitor
      4 years ago

      AlexisOlson 

       

      Yes 🙂 I want a cumulative Total of this Cumulative Baseline. In this case the cumulative Total is rd. 9M and not the 1.7M.