Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi!
Im still fairly new to using dax and power bi and im stuck on a calculation.
I need a measure to calculate the average score of a unit when an individual from the unit is selected via slicer.
I have a measure for the individual that works:
AvgStars = AVERAGE(INSPECTION_RATING[CSAT_Inspector_Score])
Rating
Order_Id | rating |
1 | 5 |
2 | 2 |
3 | 1 |
4 | 3 |
Inspection
Order_Id | Emp_ID |
1 | 2 |
2 | 3 |
3 | 4 |
4 | 7 |
Inspector
Emp_ID | Unit_Num |
2 | 20 |
3 | 20 |
4 | 30 |
7 | 70 |
Units
Unit_Num | Name |
10 | texas |
20 | michigan |
30 | new york |
70 | florida |
Thanks for the help!
Solved! Go to Solution.
@Anonymous If you are trying to compare the individual to the individuals unit avg, you can try having a DAX measure that will ignore the individual slicer:
assuming 'Inspection'[Emp_ID] is the filter for individual.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
@Anonymous If you are trying to compare the individual to the individuals unit avg, you can try having a DAX measure that will ignore the individual slicer:
assuming 'Inspection'[Emp_ID] is the filter for individual.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
This helped me a ton! and also I did discover that I needed to rearrange some of my relationships a little. These combined helped me out. Thanks again!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |