Forum Discussion
Average measure in Pivot Table with PQ
Hi az38 ,
The measure Rate card value is already created but I need to modify this in order to calculate correctly the measure.
This is current measure for Rate card value
=AVERAGEX(Rate_Card_Table, IF([Actual LCR]=BLANK(), BLANK(),Rate_Card_Table[Rate Card Value]))
But I need to modify this to calculate the average correctly. If helps I need to see the average of the filtered information only, not the average of All. So not sure if the following formulas could help on this situation : if selectedvalue or if filter
or perhaps we can use the funtion VAR / RETURN
Thanks!
Hello cristianml
I gave the averagex-formula a test and it seems to work nicely
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy