Forum Discussion
Solved
Distinct Count using criteria from multiple tables
I am trying to get a unique count of rows joined from two different tables. I want to determine how many times an employee (Employee[Employee ID]) switched to a special pay code by day, (Date[Date])....
The formula needed is the following:
Unique Count =
COUNTROWS(
SUMMARIZE(
RELATEDTABLE(Pay),
Employee[Employee ID],
'Date'[Date]
)
)
The formula needed is the following:
Unique Count =
COUNTROWS(
SUMMARIZE(
RELATEDTABLE(Pay),
Employee[Employee ID],
'Date'[Date]
)
)