Forum Discussion

Daniel_Fdrvc's avatar
Daniel_Fdrvc
Icon for Helper I rankHelper I
5 years ago
Solved

Problems with Total in matrix with measures

I've created a simple matrix and added to them a measure (with switch inside):

 

Money = SWITCH(TRUE(),

AND(Sale[Sales]>=6000,Sale[Sales]<7500),100,

AND(Sale[Sales]>=7500,Sale[Sales]<9000),300,

etc.

 

where [Sales] is another measure, that calculates sum of sales. 
Values in columns (sausis, vasaris etc.) are correct, but for TOTAL (Viso) it not SUM all the values like i suposed should be, but applies that same measure. Why this is happening and how to avoid that? This is really annoying 😞

 

 

3 Replies