Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Apply total value not to every coloumn

Hey guys,   do you know maybe if it is possible to decide on what coloumn to apply the total value? I have 3 measures (they have to stay measure, cannot change to coloumn because they are linked to...
  • AlB's avatar
    AlB
    7 years ago

    Anonymous

     

    Something like this ?

    BU Status =
    IF (
        ISFILTERED ( 'Incident Report'[Bus Unit] );   
    UNICHAR ( IF ( 'Incident Report'[Measure2 as Text] = "0"; 10003; IF ( 'Incident Report'[Measure2 as Text] = "2"; 10007; IF ( 'Incident Report'[Measure2 as Text] = "1"; 33 ) ) ) ) )

    where we're only adding the IF with the check  (in red) to what you already had.