Forum Discussion
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 ...
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,
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,
Yes ! That works perfectly ! Thank you so much !
