Forum Discussion
Help Correcting a Converted Formula
Help!!! I need some assistance and it might be advance I'm trying to convert a statement that was written in somewhat a SQL format to DAX. Not sure if this is the correct location to post this. ...
Your original query was using a lot of OR statements. Try replacing statements like:
CALCULATE (
COUNTA ( 'Query1'[ADDTL_INST] ),
'Query1'[ADDTL_INST] > 0,
'Query1'[DT_DESC] = "DEED",
'Query1'[DT_DESC] = "EASMT",
'Query1'[DT_DESC] = "SEE INSTRUMENT"
)
with
CALCULATE (
COUNTA ( 'Query1'[ADDTL_INST] ),
'Query1'[ADDTL_INST] > 0,
'Query1'[DT_DESC] IN { "DEED", "EASMT", "SEE INSTRUMENT" }
)