Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate difference between cards in fully responsive report

Good afternoon,    I am trying to insert a card that calculates the difference between two existing cards. The report that I would like to show makes it possible to show the sales of four different...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    You can create a 'What if' parameter  and modify the [Measure2].

    Measure 2 = 
CALCULATE(
    SUM(Sheet7[Sales]),
    FILTER(
        ALLSELECTED(Sheet7),
        Sheet7[Column] = MAX(Sheet7[Column]) && Sheet7[Year] = MAX(Sheet7[Year]) + [Parameter Value]
    )
)

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi v-lionel-msft, 

 

Thank you for your message. This works as long as the order does not change, but not when trying to compare two non-subsequent years, which is how the data should be presented in my case. Do you know if this is possible?

 

Best regards,

Jan

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

For example, if you want to compare the sales value of 2015 and 2017, you can change the parameter in this formula to 2。

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-lionel-msft's avatar
    v-lionel-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    Has your problem been solved?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Lionel,

       

      Unfortunately it has not yet been solved. This would require the user to manually change the formula when selecting different years for the comparison. 

       

      Best regards,

      Jan

      • v-lionel-msft's avatar
        v-lionel-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,

         

        You can create a 'What if' parameter  and modify the [Measure2].

        Measure 2 = 
CALCULATE(
    SUM(Sheet7[Sales]),
    FILTER(
        ALLSELECTED(Sheet7),
        Sheet7[Column] = MAX(Sheet7[Column]) && Sheet7[Year] = MAX(Sheet7[Year]) + [Parameter Value]
    )
)

        Please refer to my .pbix file.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.