New column: categorizing customer based on other values

Hi Anonymous ,

You can check it on:

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns#create-a-calculated-column-that-uses-an-if-functionhttps://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-calculated-columns

Ricardo

Anonymous you can do this by doing following

first create a measure

Measure 3 = 
VAR _1 =
    SUMMARIZE (
        'Table 1','Table 1'[Customer],
        "X", CALCULATE ( CONCATENATEX ( 'Table 1', 'Table 1'[Hosted Type], "," ) )
    )
VAR _2 =
    ADDCOLUMNS (
        _1,
        "CAT", SWITCH (
            TRUE (),
            CONTAINSSTRING ( [X], "Cloud" ), "Cloud",
            CONTAINSSTRING ( [X], "Cloud" ) && CONTAINSSTRING ( [X], "DC" ), "Cloud",
            CONTAINSSTRING ( [X], "Cloud" ) && CONTAINSSTRING ( [X], BLANK () ), "Cloud",
            CONTAINSSTRING ( [X], "DC" ), "DC",
            CONTAINSSTRING ( [X], "DC" ) && CONTAINSSTRING ( [X], BLANK () ), "DC",
            CONTAINSSTRING ( [X], BLANK () ), "unknown"
        )
    )
VAR _3 = CONCATENATEX(_2,[CAT],",")
VAR _4 = IF(HASONEVALUE('Table 1'[Customer]), _3)
RETURN _4

then create a calculated column

Column = CALCULATE([Measure 3], ALLEXCEPT('Table 1','Table 1'[Customer]))

The pbix is attached.