Hi everyone, I'm stuck on a formula in Power Bi and maybe one of you can help ! In the image below, you see on the left the average of bags depending on the typology of a municipalities (which is calcultated as : number of bags collected / number of participants) an I would like to apply those 3 values to each municipality based on its typology. When I try it it breaks in different values as you can see in the table on the right. Does anyone know which formula I could use ?
Thanks a lot 🙂
@Anonymous Try (3) Better Average per Category - Microsoft Power BI Community
Skip to the end of this video:
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@Anonymous Try (3) Better Average per Category - Microsoft Power BI Community
Skip to the end of this video:
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
