Forum Discussion
Sum up data avoiding double counting
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!
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.
2 Replies
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.
Thank you so much!! You are a life saviour! 🙂
