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.
I have two tables. I have a table that identifies all Team “A” employees that work with Team “B”. The second table shows all employees in team A, B & C. I created a relationship between the tables. That relationship is between the “Works with Team B” column and the “Employees” column. I then created a new table (Count of Employees table) that includes the “Employee” column from the All employees table and a “Count of works with Team B” column from the Team A employees working with team B table.
This new table(count of Employees table) only shows me employees that have a count value greater than 0 in the “Count of works with Team B” column. I would like the new table to show me all employees and if the those employees do not have a value in the “count of works with team B” column the value should be 0. It should look like below
How can I accomplish this with a Dax measure?
Solved! Go to Solution.
Hi,
You need to follow these steps:
1-Add 0 to your Measure. It would be like this:
If my answer solves your problem, please accept it as a solution so the others could find the answer easily.
Regards,
Loran
Hi,
You need to follow these steps:
1-Add 0 to your Measure. It would be like this:
If my answer solves your problem, please accept it as a solution so the others could find the answer easily.
Regards,
Loran
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 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |