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 gree...
  • 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] ) )
    )
    )
     
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper 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.