Switch returning percentage and whole numbers

[Anonymous]

Hi,

I have a switch statement which returns both the total number of enquiries and sales as well as a percentage that divides e.g. enquiries created with total number of transactions.

The way it is now, the supposed percentage value returns 0.01 and not 1.00%.

Is there any workaround regarding this?

I have set each of the measures created to either decimal or whole number and the percentage measures to % with 2 decimals but it takes the whole/decimal number. 

Kind regards,

Jari

[amitchandak]

@Anonymous , In measure and column tool you have % icon , press that you should get %

[Anonymous]

That is already used for each measure.

The first 3 statements return whole numbers such as 100 000 while the 3 others return 0.01 when I want it to return 1.00%. Each measure is already configured under formatting but it doesn't reflect it when it is used in the visuals. I don't want % for all measures

[Anonymous]

@Anonymous 

Mixing different outputs in one measure is never a good idea. If you really need to do it, then you've got 2 choices: return the result as text formatted the way you want or use calculation groups. The first choice is simple but such a measure will have to be a top-level measure (meaning you won't be able to use it correctly in other measures). The second choice is more complex but it's the preferred way as it allows the measure to be used in other measures as it'll return the type it should (not only text).

[amitchandak]

@Anonymous , this can best be done with calculation groups( I think you are using measure slicer

calculation groups

https://www.youtube.com/watch?v=vlnx7QUVYME

https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/