Forum Discussion
Return Different Measures Based On Matrix Row Values
Hello - I have the following Matrix visual: Rows: - 'D SalesRep'[Name] - 'D Customer'[Name] - 'D SalesType'[Name] - 'D Product'[Group Code Description] - 'D Product'[Code] Values (cu...
Good catch. So this is the entire 'F Sales' table, and there are no common products sold by both Sales Reps.
I did notice that the Total for [M Contract] is the sum of row values,
whereas the Total for [M Direct] is NOT the sum of row values.
Not sure, but I'm guessing this is because [M Contract] is additive & [M Direct] is non-additive.
Something like what Ferrari describes here: https://www.youtube.com/watch?v=6rgAkejrup8
Ferrari mentions that averages are non additive measures.
So I'm wondering if because there is a division operator in [M Direct], it causes it to be non-additive?
Regards,
Nathan
WinterMist
You are right. [M Direct] is non-additive. But I guess it makes sense to force additivity.
