Forum Discussion
ErnestoSanchez
6 years agoFrequent Visitor
Average ov Averages
Hi everybody, Thanks for take your time to help me. I have a two clustered column charts In the first one I show absolut values (80, 54, 198, etc.) In the second one I show relatives values r...
parry2k
Super User
6 years agoErnestoSanchez try this measure
Measure = AVERAGEX( VALUES ( Consolidado[PAIS] ), [GraduadosSIPrograma%] )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
ErnestoSanchez
6 years agoFrequent Visitor
Thank parry2k .
As you can see, I am using a Hierarchy (sexo, pais, financiador, socio, sede, número de promoción) and a Drill.
Your solution works fine when I have the Drill on [PAIS],
But, when I change the selection... It stop working fine. It show me a bad result.
Any idea...??