Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Variance Calculation Between Matrix Visuals

Hi,   I have 2 Matrix Visuals that the user can make filtered selections against: "GROUP 1" and "GROUP 2". Below those is a 3rd visual, "VARIANCES", this is meant to show the difference between th...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous solution attached, you have to have common dimension table to compare and I did this using DAX, you can always do that in the backend or in PQ.

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

     

  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous solution attached, see the duplicate page, you need to use columns from common dimension SM0 and also changed the relationship to "one to many" between sm0 and sm1 and sm2

     

    Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous it is not easy to provide the solution looking at the screenshots. Better to provide a sample pbix file using one drive/google drive to get your answer quickly. Remove any sensitive information before sharing.