Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

IF-CALCULATE

Hello All,  I want to filter with rating as per below  Total Sales < 8000  = 1  Total Sales 8000  to 10000 = 2  Total Sales  > 10000 = 3    I have created new column with follwing filter and it...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

try SWITCH()

Measure = 
var _SumPrice = CALCULATE(SUM(Trans[Price.PRICE]),ALLEXCEPT(Trans,Trans[CUSTNUM1]) )

RETURN
SWITCH(TRUE(),
_SumPrice  < 8000 , "1",
_SumPrice  > 8000 && _SumPrice < 10000, "2",
"3"
)