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.
Hello,
I need to make a graph showing how many times each person has their name in column "Done by" and "Checked by". The issue is that the graph "Checked By" is correct but the graph for "Done by" is not - it's appearing the values of the column "Checked by" ("Done by" does not even have black values).
Could you kindly advise on where the error might be coming from and how to correct? I've already tried to start a new one from scratch and I ended up with the same problem.
https://imgur.com/FuPlQp4 (Graphs described above.)
Thank you in advance.
Solved! Go to Solution.
Hi @alhashmi ,
Create one active relationship and on inactive relationship.
Use USERELATIONSHIP() function to create a measure for the inactive column.
Measure = CALCULATE(COUNT('Table'[Checked by]),USERELATIONSHIP('Table'[Checked by],Who[person]))
Result would be shown as below.
Best Regards,
Jay
Hi @alhashmi ,
Create one active relationship and on inactive relationship.
Use USERELATIONSHIP() function to create a measure for the inactive column.
Measure = CALCULATE(COUNT('Table'[Checked by]),USERELATIONSHIP('Table'[Checked by],Who[person]))
Result would be shown as below.
Best Regards,
Jay
Thank you for the quick response.
It's connected via relationships, it has the values "Person A" "Person B" "Person C" and "Person D". At first I tried to use "Done by"/"Checked by" as axis, but due to the error I tried a different way to test out.
Since your relationship from the Who table can only be active with one of those fields at a time, you will need to use 1 of 2 approaches to count the other. Assuming the relationship is active with Done By, here are two solutions for Checked By
1. Make an inactive relationship between the People column and the Checked By column. Use a measure like this
Checked By Count = CALCULATE(COUNTROWS(Data), USERELATIONSHIP(Who[People], Data[Checked by]))
2. Use a measure like this
Checked By Count = CALCULATE(COUNTROWS(Data), TREATAS(VALUES(Who[People]), Data[Checked by]), ALL(Data[Done by]))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |