topic Re: Switch returning percentage and whole numbers in DAX Commands and Tips

Switch returning percentage and whole numbers

Anonymous — Thu, 15 Apr 2021 07:11:38 GMT

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

Re: Switch returning percentage and whole numbers

amitchandak — Thu, 15 Apr 2021 07:16:21 GMT

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

Re: Switch returning percentage and whole numbers

Anonymous — Thu, 15 Apr 2021 07:21:21 GMT

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

Re: Switch returning percentage and whole numbers

amitchandak — Thu, 15 Apr 2021 09:14:09 GMT

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/

Re: Switch returning percentage and whole numbers

Anonymous — Thu, 15 Apr 2021 22:29:23 GMT

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