Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

PLEASE help with this equation

I have two types of data points for certain neighborhoods. First is the type of customer, and second is the amount of customers. Table 1 Location      Classification    Count Location A    Resi...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Try:

     

    Sum Count = SUM(Table1[Count])

     

     

     

    Population =
SUMX (
    ADDCOLUMNS (
        Table1,
        "_calc",
            CALCULATE (
                IF (
                    MAX ( Table1[Classification] ) = "Commercial" && MAX(Table1[ Location]) = "Location B",
                    [Sum Count] * 2.7,
                   IF( MAX ( Table1[Classification] ) <> "Commercial" && MAX(Table1[ Location]) = "Location A", [Sum Count] * 3
                )
            )
)
    ),
    [_calc]
)

     

     

     

     

     

     

     

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Try:

 

Sum Count = SUM(Table1[Count])

 

 

 

Population =
SUMX (
    ADDCOLUMNS (
        Table1,
        "_calc",
            CALCULATE (
                IF (
                    MAX ( Table1[Classification] ) = "Commercial" && MAX(Table1[ Location]) = "Location B",
                    [Sum Count] * 2.7,
                   IF( MAX ( Table1[Classification] ) <> "Commercial" && MAX(Table1[ Location]) = "Location A", [Sum Count] * 3
                )
            )
)
    ),
    [_calc]
)