Forum Discussion
DAX Count Based on 2 Name (Key) Columns
Koushikrish , You need to have a username table, if you do have to create one
username = distinct(union(distinct(Table1[Recepient]),distinct(Table2[Nominator])))
Join with both tables. One join will be inactive.
You just need a count/distintcount measure.
For inactive use userelationship to activate relation
Count(Table[ID]) //active join
Assume Nominator is inactive
calculate(Count(Table[ID]) ,userelationship (username[Recepient] , Table[Nominator]) )
Koushikrish , You need to have a username table, if you do have to create one
username = distinct(union(distinct(Table1[Recepient]),distinct(Table2[Nominator])))
Join with both tables. One join will be inactive.
You just need a count/distintcount measure.
For inactive use userelationship to activate relation
Count(Table[ID]) //active join
Assume Nominator is inactive
calculate(Count(Table[ID]) ,userelationship (username[Recepient] , Table[Nominator]) )
amitchandak : That worked as I expected. Also there was only one table and not multiple so I used the 2 different columns (Recipient and Nominator). Thanks for your help!!