Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

CASE STATEMENT for Measures

Can I get the equivalent DAX statement for the following mesures.   Measure1:  COUNT( CASE WHEN TABLE1.Submit_Date >= TABLE1.StartDate AND TABLE1.OrderType IN ('Sweaters','Rugs') THEN TABLE1.Or...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

For Measure1:

I am able to get the following work 

 

Measure 1:=CALCULATE(COUNTA(TABLE1[OrderId]), TABLE1[OrderType] IN {"Sweaters","Rugs"})

 

Measure1:=COUNTAX(FILTER(TABLE1,TABLE1[SubmitDate]>=TABLE1[StartDate]),TABLE1[OrderId])

 

I am unable to combine using the logic u have given.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

This Syntax now does not throw errors

Measure 1:=CALCULATE(COUNTA(TABLE1[OrderId]), TABLE1[OrderType] IN {"Sweaters","Rugs"},FILTER(TABLE1,TABLE1[SubmitDate]>=TABLE1[StartDate]))