Forum Discussion
CASE STATEMENT IN DAX
Here is my case statement in SQL
CASE WHEN T4. SALES_CHANNEL IN (X,Y,Z) THEN SUM(T3.CUSTID)/SUM(T2.TRANID)
ELSE SUM(T1.TICKETID)/SUM(T2.TRANID)
ELSE 0 END AS NEW_RATIO
I started with this DAX but I am unable to get switch or IF work here
NEW_RATIO = DIVIDE(SUM(T1.TICKETID),SUM(T2.TRANID),0)
Try
=If(T4[SALES_CHANNEL] IN {X,Y,Z},divide(SUM(T3[CUSTID]),SUM(T2[TRANID])),divide(SUM(T1[TICKETID]),SUM(T2[TRANID])))
1 Reply
Try
=If(T4[SALES_CHANNEL] IN {X,Y,Z},divide(SUM(T3[CUSTID]),SUM(T2[TRANID])),divide(SUM(T1[TICKETID]),SUM(T2[TRANID])))