Nested IF measure

[Durbslaw]

Hi Forum,

Thanks for reading and responses where applicable, technically this is not a measure but I have...

Programme =
if('Department'[ProgrammeCode] = 10000000, "Prog 1",
if('Department'[ProgrammeCode] = 20000000, "Prog 2" ,
if('Department'[ProgrammeCode] = 30000000, "Prog 3" ,
if('Department'[ProgrammeCode] = 40000000, "Prog 4" ,
if('Department'[ProgrammeCode] = 50000000, "Prog 5" ,
if('Department'[ProgrammeCode] = 60000000, "Prog 6" ,
if('Department'[ProgrammeCode] = 70000000, "Prog 7" ,
if('Department'[ProgrammeCode] = 80000000, "Prog 8" ,BLANK()))))))))

The issue is the engine does not recognise the field name 'ProgrammeCode'. I have checked the spelling and even modified a quick measure to retain the field name.

[Samarth_18 · Accepted solution]

HI @Durbslaw ,

You could create a measure as below:-

Programme =
SWITCH (
    TRUE (),
    MAX ( 'Department'[ProgrammeCode] ) = 10000000, "Prog 1",
    MAX ( 'Department'[ProgrammeCode] ) = 20000000, "Prog 2",
    MAX ( 'Department'[ProgrammeCode] ) = 30000000, "Prog 3",
    MAX ( 'Department'[ProgrammeCode] ) = 40000000, "Prog 4",
    MAX ( 'Department'[ProgrammeCode] ) = 50000000, "Prog 5",
    MAX ( 'Department'[ProgrammeCode] ) = 60000000, "Prog 6",
    MAX ( 'Department'[ProgrammeCode] ) = 70000000, "Prog 7",
    MAX ( 'Department'[ProgrammeCode] ) = 80000000, "Prog 8",
    BLANK ()
)

And column can be create as below:-

Programme =
SWITCH (
    TRUE (),
    'Department'[ProgrammeCode] = 10000000, "Prog 1",
    'Department'[ProgrammeCode] = 20000000, "Prog 2",
    'Department'[ProgrammeCode] = 30000000, "Prog 3",
    'Department'[ProgrammeCode] = 40000000, "Prog 4",
    'Department'[ProgrammeCode] = 50000000, "Prog 5",
    'Department'[ProgrammeCode] = 60000000, "Prog 6",
    'Department'[ProgrammeCode] = 70000000, "Prog 7",
    'Department'[ProgrammeCode] = 80000000, "Prog 8",
    BLANK ()
)

BR,

Samarth