Forum Discussion
Solved
SQL CASE Statement to DAX Measure
Hi All, Need help to replicate the below Case statement into a DAX measure: SUM( CASE WHEN VALUE_TYPE = '070' AND VALUE_TYPE_DETAIL = '06' THEN AMOUNT ...
Yes, sorry I misunderstood your goal. Try this, it should perform much better as well.
TEST = CALCULATE ( SUM ( 'TableName'[Amount] ), 'TableName'[VALUE_TYPE] = "070", 'TableName'[VALUE_TYPE_DETAIL] = "06" )
TEST =
IF (
SELECTEDVALUE ( 'TableName'[VALUE_TYPE] ) = "070"
&& SELECTEDVALUE ( 'TableName'[VALUE_TYPE_DETAIL] ) = "06",
SUM ( 'TableName'[AMOUNT] ),
0
)Thank you for your response jmalone.
However this gives me a 0 in each row as well as a 0 in the grand total.
Moreover, this measure was very slow to populate (I am working with a million records)
Any ideas?
Yes, sorry I misunderstood your goal. Try this, it should perform much better as well.
TEST = CALCULATE ( SUM ( 'TableName'[Amount] ), 'TableName'[VALUE_TYPE] = "070", 'TableName'[VALUE_TYPE_DETAIL] = "06" )
