Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there, I'm realtively new to PowerBI and I'm hoping someone here can help me out.
I am trying to create a measure that gives me the difference of AvgpriceTM from the total average price.
i.e. (65 - 15.50)...(42-15.50) etc.. Any help would be greatly appreciated! 🙂
Solved! Go to Solution.
@seanlim ,
You need a measure like an example
Average(Table[Price]) - calculate(Average(Table[Price]) , allselected())
or
Average(Table[Price]) - calculate(Average(Table[Price]) , all())
@seanlim ,
You need a measure like an example
Average(Table[Price]) - calculate(Average(Table[Price]) , allselected())
or
Average(Table[Price]) - calculate(Average(Table[Price]) , all())
This worked, thanks so much!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |