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...
cristianmlPost Prodigy
Post ProdigyHi Jimmy801 ,
I tried to add "RELATED" but I couldn't.
The table from where comes the Measure Actual LCR comes from a table that is not a Column, is a category. LCR means Cost rate (marked in yellow in the table) : See the screenshot:
So how can I modify the RELATED in this case so can work properly ?
Thanks.
Jimmy801
Community Champion
Community ChampionHello cristianml
sorry, but I can't follow anymore. I don't know the relationship nor do I understand your datamodel. As shown in my examples the measure I proposed is working (to check another column if it's empty or not equal 0. Now you tell me that is category next.
I'm very sorry, but I'm not able to help anymore
Jimmy