Forum Discussion

mar100's avatar
mar100
Frequent Visitor
6 years ago
Solved

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 De...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    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.

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

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's avatar
    mar100
    Frequent Visitor
    6 years ago

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