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

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

In your new UNION table, can you set the formatting of the columns?

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

Hi Greg_Deckler

 

Yes, I can set the formatting of the columns. But instead of showing "0,02", when I choose a decimal number, it just shows "2". And therefore everthng becomes the valuex100, when i format as Percent.

It seems strange, because I when I format the measures as numbers, they should go over as "0,02" and not "2". That should only happen when they are formatted as percentages.