Forum Discussion
Filter Context for Distinct Counts
Hello, I have a data model that includes a User table, which includes an individual name and the team in which they belong to, that is joined to a transactional table (Owner History) by User Name...
Hi,
Even the simple count distinct of the column case# would solve your need.
Not getting why you need a separate DAX. can you clarify my understanding ?
The Screenshot for the same is below.
Try one of these
1) use person or team from lookup table in visual
2) turn on cross filter direction to both for the relationship
3) force crosfikter in Dax.
See this example. https://1drv.ms/u/s!AuCIkLeqFmlhhJgzLZ6jPcWgLGu3Yw
1) use person or team from lookup table in visual
2) turn on cross filter direction to both for the relationship
3) force crosfikter in Dax.
See this example. https://1drv.ms/u/s!AuCIkLeqFmlhhJgzLZ6jPcWgLGu3Yw