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 table with the week numbers.

 

I'm stuck with calculating the % difference between 2 weeks, like shown below.

 

Basicaly, i will have to see the difference in % from the same measures.


Is it possible.

Need Help
  • Zubair_Muhammad's avatar
    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's avatar
    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
    )
        & "%"
)

10 Replies

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

      Hi Siva, 

       

      that's correct,

       

      With quick measures there are possibilities but not when it's coming from same data source.

       

      Thanks

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Icon for Community Champion rankCommunity 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] )
            )
        )
)