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

8 years ago

HI jurgenvd

Try adding this MEASURE.

Bascially for each row it is intended to give you the [Incidents Opened]....For total....the difference between max and highest week

Measure =
IF (
    HASONEVALUE ( TableName[WeekNumber] ),
    [Incidents Opened],
    CALCULATE (
        [Incidents Opened],
        FILTER (
            ALLSELECTED ( TableName[WeekNumber] ),
            TableName[WeekNumber] = MAX ( TableName[WeekNumber] )
        )
    )
        - CALCULATE (
            [Incidents Opened],
            FILTER (
                ALLSELECTED ( TableName[WeekNumber] ),
                TableName[WeekNumber] = MIN ( TableName[WeekNumber] )
            )
        )
)

Zubair_Muhammad

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
    )
        & "%"
)

Zubair_Muhammad

Community Champion

8 years ago

HI jurgenvd

Try adding this MEASURE.

Bascially for each row it is intended to give you the [Incidents Opened]....For total....the difference between max and highest week

Measure =
IF (
    HASONEVALUE ( TableName[WeekNumber] ),
    [Incidents Opened],
    CALCULATE (
        [Incidents Opened],
        FILTER (
            ALLSELECTED ( TableName[WeekNumber] ),
            TableName[WeekNumber] = MAX ( TableName[WeekNumber] )
        )
    )
        - CALCULATE (
            [Incidents Opened],
            FILTER (
                ALLSELECTED ( TableName[WeekNumber] ),
                TableName[WeekNumber] = MIN ( TableName[WeekNumber] )
            )
        )
)