Forum Discussion

WinterMist's avatar
WinterMist
Icon for Impactful Individual rankImpactful Individual
3 years ago

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...
WinterMist's avatar
WinterMist
Icon for Impactful Individual rankImpactful Individual
3 years ago

It just hit me.  I think the SUMX iterator over 'D SalesType' does it.

 

 

 

If anyone has a different suggestion, let me know.

 

Regards,

Nathan

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

WinterMist 
Good job!

For some reason the total shows 189 instead of 192. Seems there are common products sold by both salesReps. I guess they still need to be counted twice?