Problem showing percentagen in UNION

[kjartank]

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.

[v-ljerr-msft · Accepted solution]

Hi @kjartank,

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

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]

@v-ljerr-msft

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

[Greg_Deckler]

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

[kjartank]

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.