Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |