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...
venal
Memorable Member
Memorable MemberAnonymous
small change on the sql query.
select distinct a.Name
from FlagTable a
where a.Flag=1
and not exists(select 1 from FlagTable b where b.Flag=0 and a.Name=b.Name)
we will expect someone need to help with DAX.