Average in Measure

[ajimenez]

Hi everyone,

I have the following table:

I need to create a measure that allow me get this results:

EXPECTED RESULT BY SUP-01 = SUM(60, 45, 51, 63) ==>  219
EXPECTED RESULT BY SUP-02 = SUM(35, 45, 50) ==>  130

Can you help me please?

Thanks!!

[Greg_Deckler · Accepted solution]

Seems like this desing pattern would apply:

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

[ajimenez]

Hi @Greg_Deckler

I really appreciate your help, however the solution specifies my problem and I found it in this forum thread

https://community.powerbi.com/t5/Desktop/Summarizing-data/td-p/107493

Thanks so much!!