Forum Discussion
Solved
Filtering and Count issues
Hi, new to DAX and Powerbi, I have two tables in a 1:M relationship: TableA (1) - GUID (key) - Name TableB: (M) - ID (key) - GUID - TYPE Where type can be 1 or 2 I am trying...
OK, how about this
Count of Records = countrows(TableB)
Count of any type 1 = calculate([count of records],TableB[Type]="1")
Count of any type 2 = calculate([count of records],TableB[Type]="2")
Count only type 1 =SUMX(TableA,if([Count of any type 1] >0 && [Count of any type 2] = 0,1))
Count only type 2 =SUMX(TableA,if([Count of any type 1] =0 && [Count of any type 2] > 0,1))
Count always both =SUMX(TableA,if([Count of any type 1] >0 && [Count of any type 2] > 0,1))
Thanks, that seems to do the trick :)