Forum Discussion
cristianml
Post Prodigy
Post ProdigyAverage measure in Pivot Table with PQ
Hi, I have an issue with a meaure that shows the average but not the one I Expected. If you see in the screenshot below it shows the average 93 but should be 86. This is because is taken the aver...
Jimmy801
Community Champion
Community ChampionHello cristianml
you can use this measure here
=AVERAGEX(Rate_Card_Table; IF(Rate_Card_Table[Actual LCR]=BLANK(); BLANK();Rate_Card_Table[Rate Card Value]))
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
cristianmlPost Prodigy
Post ProdigyHi Jimmy801 ,
I tried it but is not working: Now is worse: Showing an average of 97 and should be 86 as you see in the screenshot.
Note: The measure Actual LCR comes from another table:
- Jimmy801Hello
Then you should put the correct table name in front of the column and surround it with the releated-function.
Good luck
Jimmy