Create a table with a different measure for each row

Hi,

With "If" statements? (if category = category 1; measure 1; if cat= cat 2.... etc)

Hi Anonymous,

In addition, you should also be able to use SWITCH function in this scenario. The formula below is for your reference. :smileyhappy:

AMOUNT =
IF (
    HASONEVALUE ( 'Table1'[CATEGORY] ),
    SWITCH (
        VALUES ( 'Table1'[CATEGORY] ),
        "Category 1", [measure1],
        "Category 2", [measure2],
        "Category 3", [measure3],
        "Category 4", [measure4],
        "Category 5", [measure5],
        "Category 6", [measure6],
        0
    )
)

Regards