Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm new to Powerbi, and I'm developing a board. I have three tables:
Now, I want to find a count of emp ids that belong to a particular city in Table 2. For some reason the city filter does not work in Table 1. Can someone help me with this kind of problem? Happy to explain more in case I'm not clear on my question.
Solved! Go to Solution.
it should work If you count emp id in tbl 3, like
Measure 2 =
DISTINCTCOUNT( 'Table3'[EmployeeID] )
Change filter direction between table1 and table3 with both direction.
Then use distinctcount DAX funtion.
Best Regards
Maggie
@Ramesh-iTalent , You need to count from table 3 and Table 1 and Table 2 should be 1-M relationship with Table 3
Distinctcount(Table3[emp id])
it should work If you count emp id in tbl 3, like
Measure 2 =
DISTINCTCOUNT( 'Table3'[EmployeeID] )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |