Forum Discussion

jurgenvd's avatar
jurgenvd
Icon for Helper I rankHelper I
8 years ago
Solved

measure difference in percentage from same measures

Hi All   I'm stuck with my Matrix, can someone help me.   I have 3 measures   Incidents opened Incidents closed Average incidents in open state  per week   next to those measures i have a t...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Hi jurgenvd

 

Do you want that the same MEASURE should show NUMBERS in ROWS and PERCENTAGE in ROW TOTAL???

jurgenvd's avatar
jurgenvd
Icon for Helper I rankHelper I
8 years ago

hi Zubair_Muhammad

 

Yes correct.

 

I would like to have the same but now reflected in percentage.

 

so the % should be the increase between the 2 reported weeks. 

 

Many thanks !

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    8 years ago

    jurgenvd

     

    Please give this a shot

     

    Measure =
IF (
    HASONEVALUE ( TableName[WeekNumber] ),
    [Incidents Opened],
    ROUND (
        (
            CALCULATE (
                [Incidents Opened],
                FILTER (
                    ALLSELECTED ( TableName[WeekNumber] ),
                    TableName[WeekNumber] = MAX ( TableName[WeekNumber] )
                )
            )
                / CALCULATE (
                    [Incidents Opened],
                    FILTER (
                        ALLSELECTED ( TableName[WeekNumber] ),
                        TableName[WeekNumber] = MIN ( TableName[WeekNumber] )
                    )
                )
                - 1
        )
            * 100,
        1
    )
        & "%"
)