Forum Discussion

IDAX's avatar
IDAX
Frequent Visitor
1 year ago

dynamic diff calculation row in matrix

Dear Power BI Gurus !

 

I'm struggling for some time already with creating of dynamic calculation which would return difference between selected rows in matrix. Here's a sample of raw data:

 

Then, matrix should enable to select Foorecast ID in slicer while the calculation row should indicate a diff (Forecast variance) between last and previous forecast:

I tried to use measures for each Forecast ID and it worked. It calculates the diff but if I select two particular Forecast IDs I get all measures rows visible in matrix (selected ones are with values and not selected ones with empty cells). What I need is to visualize only selected Forecast IDS and Forecast variance row at the end.

 

Do You have a smart solution for it ?

I'd appreciate Your support.

Have a great day !

 

 

 

 

11 Replies

    • IDAX's avatar
      IDAX
      Frequent Visitor

      The slicer will be selecting Forecast ID

      • lbendlin's avatar
        lbendlin
        Super User

        But then you are showing all forecast IDs in the visual.  There's no need for the slicer?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, IDAX 

    Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

     

    Best Regards

    Yongkang Hua