Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DistinctCount grouping by

Hi, I've never understood how to do a distinct count with a group by on a visual that has many fields included the one I want to distinct count. I explain my problem with an example: I have this vis...
DAX
distinctcount
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

 

5 CC =
VAR currentthree = 'Table'[3]
VAR currentone = 'Table'[1]
VAR groupbythree =
FILTER ( 'Table', 'Table'[3] = currentthree && 'Table'[1] = currentone )
RETURN
COUNTROWS ( groupbythree )