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]
)

     

     

     

     

     

     

     

YukiK's avatar
YukiK
Impactful Individual
4 years ago

You'd need to add an additional condition that checkes if the location is A or B, etc, in addision to checking if "Commercial".

 

Hope that helps!