How to set a filter in two different columns then count the remaining rows in Dax.
measure = CALCULATE (
COUNTROWS( df )
,df[column1] IN { "col1", "col2", "col2" }
&&df[column2] <> 0
)
>Solution :
Does this work?
measure = CALCULATE (
COUNTROWS( df )
,df[column1] IN { "col1", "col2", "col2" }
&& VALUE(df[column2]) <> 0
)