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] ) )
    )
    )
     
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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] ) )
)
)