Forum Discussion

Lucas_Radebe's avatar
Lucas_Radebe
Regular Visitor
2 years ago
Solved

Matrix Total

Hi,

 

I am using a DAX measure to calculate price variance by product :

VPM PRICE = SUMX (VALUES ('Product'[Product Group']), <calculation coding in here>

When I produce a matrix by country, the total price variance is as I wish it to be.

 

When I produce a matrix by Region (with multiple countries), I want the total to add up the variances per country.  Instead, the measure works out the total variance for the Product across the Region (the products are not unique to one country).

 

Does anyone please know how I can change the DAX to achieve the summation of the country level variances in my matrix ?

 

Many Thanks

Peter

     

Need Help
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi Lucas_Radebe 

     

    What about sumxing your measure over the regions' dimension table country field or something equivalent to that in your specific data model?   The measure below will force the summations across countries will be correctly calculated.  

    Best regards,

2 Replies

  • DataNinja777's avatar
    DataNinja777
    Super User
    2 years ago

    Hi Lucas_Radebe 

     

    What about sumxing your measure over the regions' dimension table country field or something equivalent to that in your specific data model?   The measure below will force the summations across countries will be correctly calculated.  

    Best regards,

    • Lucas_Radebe's avatar
      Lucas_Radebe
      Regular Visitor
      2 years ago

      Yes !  That works perfectly !  Thank you so much !