Sum up data avoiding double counting

[mar100]

Hi guys!

I've got the following data table.

I need to create a measure to calculate the total number of households.  

The number of households changes only on Regional and Demographical levels. In the picture above, we can see Demo Group - 1 and two regions - West and South. Power BI, however, sums it up at every level, i.e. total is 60. 

I would greatly appreciate any help on this!!

Thank you!

[jdbuchanan71 · Accepted solution]

Hello @mar100 

This measure should get you what you are looking for.  I tested it with an additional demo split add to check.  You will just have to change thename of your table.

Measure = 
SUMX ( 
    SUMMARIZE( Data, Data[Region], Data[Demo Split] ),
    CALCULATE ( MAX ( Data[Number of households] ) )
)

 

If this solves your issues please mark it as the solution. Kudos 👍 are nice too.

[mar100]

Thank you so much!! You are a life saviour! 🙂