Forum Discussion
Post ProdigyAverage measure in Pivot Table with PQ
Post Prodigy
Community Championwhat field do you want to aggregate? Rate Card Value or Actual LCR ?
Measure = CALCULATE(
AVERAGE(Rate_Card_Table[Actual LCR]);
NOT(ISBLANK([Actual LCR]))
)do not hesitate to give a kudo to useful posts and mark solutions as solution
- cristianml
Hi az38 ,
I want to modify the measure Rate Card Value in order to calculate the correct average.
The Rate Card Value comes from Rate card table and the Actual LCR comes from RT Actual Table.
Thanks!
- az38
So, I as see on the screenshot you try to create a measure called "Rate Card Value" to create average of Rate Card Value?
Its impossible, try to rename your measure
do not hesitate to give a kudo to useful posts and mark solutions as solution
- cristianml
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!