Forum Discussion
Dax - distinctcount as SQL query (no exists)
I need a Dax that count the Names distinctly that has the Flag=1 but don´t has the Flag=0 In SQL I could do something like this: Select count(distinct Name) Qtd from Table1 A where Flag = 1...
Hi Anonymous
Is there any way achieve the same result without create the columns step? Is it possible to do all in a measure?
I aprecciate for you help.
Hi Anonymous ,
The following measure might be helpful for you:
Measure 2 = CALCULATE(DISTINCTCOUNT('table'[Name]),FILTER('table',MIN('table'[Flag])>0))
And the result would be shown as below:
Best Regards,
Jay