Forum Discussion

kjartank's avatar
kjartank
Icon for Helper II rankHelper II
9 years ago
Solved

Problem showing percentagen in UNION

Hi   I want to use UNION on a number of columns and the same number of measures, to make it more manageable to show in tables. I have made measures, to show the percentage of respondents with a cer...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi kjartank,

     

    Could you try using the formula below to see if it works in your scenario? :smileyhappy:

    Don't know =
UNION (
    SELECTCOLUMNS ( Tabel1; "Attribute"; "01."; "Answer"; Tabel1[% check-in] / 100 );
    SELECTCOLUMNS ( Tabel1; "Attribute"; "02."; "Answer"; Tabel1[% Cabin] / 100 );
    SELECTCOLUMNS ( Tabel1; "Attribute"; "03."; "Answer"; Tabel1[% Service] / 100 )
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi kjartank,

 

Could you try using the formula below to see if it works in your scenario? :smileyhappy:

Don't know =
UNION (
    SELECTCOLUMNS ( Tabel1; "Attribute"; "01."; "Answer"; Tabel1[% check-in] / 100 );
    SELECTCOLUMNS ( Tabel1; "Attribute"; "02."; "Answer"; Tabel1[% Cabin] / 100 );
    SELECTCOLUMNS ( Tabel1; "Attribute"; "03."; "Answer"; Tabel1[% Service] / 100 )
)

 

Regards

  • kjartank's avatar
    kjartank
    Icon for Helper II rankHelper II
    9 years ago

    v-ljerr-msft

     

    That worked beautifully! Thanks a lot :) I wasn't aware that I could put calculations in a UNION formula.