Forum Discussion

Lucas_Radebe's avatar
Lucas_Radebe
Regular Visitor
2 years ago
Solved

Matrix Aggregation

Hi, I am using Power BI for the first time and have set up a matrix (example below). For volume variance, the brand total uses the same calculation as the Product Group.  Instead I would like it to...
Need Help
  • Wilson_'s avatar
    Wilson_
    2 years ago

    Hey Lucas,

     

    Try something like the below for your Volume Variance measure:

    Volume Variance =
SUMX (
    VALUES ( Table[Brand] ),
    [Units Variance] * [LY Price per unit]
)

     

    If that doesn't work, can you please share your data model? I've made some assumptions about the model in writing out the syntax above.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

Wilson_'s avatar
Wilson_
Icon for Memorable Member rankMemorable Member
2 years ago

Hey Lucas,

 

Try something like the below for your Volume Variance measure:

Volume Variance =
SUMX (
    VALUES ( Table[Brand] ),
    [Units Variance] * [LY Price per unit]
)

 

If that doesn't work, can you please share your data model? I've made some assumptions about the model in writing out the syntax above.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

 

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.