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 certain answer. The measures look like this and work as they should.

% NAME = 
VAR lastperiod =
    CALCULATE ( MAX ( Tabel1[turnr] ); ALLNOBLANKROW ( Tabel1 ) )
RETURN
    DIVIDE (
        CALCULATE (
            COUNTROWS ( Tabel1 );
            FILTER (
                Tabel1;
                Tabel1[turnr] = lastperiod
                    && Tabel1[COLUMN] = "Don't know/no experience"
            )
        );
        CALCULATE (
            COUNTROWS ( Tabel1 );
            FILTER ( Tabel1; Tabel1[turnr] = lastperiod )
        )
    )

When I try to make a UNION table, I run into problems. The code I've written looks like this.

 

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

It should load fine, but I only get a whole number from the table. I simply can't get it to show me a 0,02 or a percentage. What am I doing wrong?

 

 

Thanks in advance.

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

4 Replies

  • 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.

  • 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.