percentage in whole number

[kannanAhammed]

Hi,

i am converting a decimal value to percentage. please see the dax function i have used.

TimelyResponseMaterialInspections = VAR V = CALCULATE (

MAX ( 'MER'[This month] ),

FILTER (

'MER',

'MER'[Title] =="Material Inspections"

)

) Return

IF(ISBLANK(V),0,FORMAT(V,"Percent" ))

"MER'[This month]" will have values such as "0.775193798" once converted to percentage it will be "77.53%". i would like to remove the decimal and have the output to "77%".

will this be possible?

[V-pazhen-msft]

@kannanAhammed

Generally, you need to selected the measure from the right panel and then just change the format and decimal places on the top ribbon.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harshnathani · Accepted solution]

Hi @kannanAhammed ,

Try this measure and then click on the measure and then format it from the ribbon to % .

TimelyResponseMaterialInspections =
VAR V =
    CALCULATE (
        MAX ( 'MER'[This month] ),
        'MER'[Title] == "Material Inspections"
    )
RETURN
    IF (
        ISBLANK ( V ),
        0,
        V,
          
        )
    )

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[kannanAhammed]

Thanks @harshnathani 

[harshnathani]

Hi @kannanAhammed ,

TimelyResponseMaterialInspections =
VAR V =
    CALCULATE (
        MAX ( 'MER'[This month] ),
        'MER'[Title] == "Material Inspections"
    )
RETURN
    IF (
        ISBLANK ( V ),
        0,
        FORMAT (
            V,
            "Percent"
        )
    )

Percent by default will give you 2 decimal places rounding off.

You cna also format this measure in the ribbon above.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-ribbon

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[kannanAhammed]

@harshnathani thanks for the reply, but when i run the Dax function provided I get 0 as output. And the ribbon is dissabled.

@AllisonKennedy yes you are right, I only want the decimal gone, but if the blanks can be removed with DAX i will take that too 🙂

[harshnathani]

Hi @kannanAhammed ,

Select the measure in the field pane, your ribbon will be enabled.

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[kannanAhammed]

[AllisonKennedy]

@harshnathani
Please can you elaborate on what you changed from the original poster's measure? I would love to learn the secret, but can't spot the difference.
Thanks!

[harshnathani]

Hi @AllisonKennedy ,

There was a FILTER applied to the Table, which I removed.

Regards,

Harsh Nathani

[AllisonKennedy]

@harshnathani
Ah yes, thanks! I knew there was something, ok, so now comes my learning and the real question:

I know CALCULATE works with column filters and prefers them, but the FILTER function should still provide the same result as your column filter in this example? What am I missing?

[harshnathani]

HI @AllisonKennedy ,

This is what I learnt from this video by Jeffery Wang

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

Watch the section from 35 to 45 min.

Regards,

Harsh Nathani

[AllisonKennedy]

Thanks @harshnathani for answering my silly questions, hopefully our dialogue will be helpful to someone. The video you have posted does do a nice job of explaining the differences in filter options when using CALCULATE, but I understood the question to be completely unrelated to the use of filter or calculate and more of an origin in the behaviour of FORMAT

So here is my understanding of this situation:

Using the FILTER() function inside CALCULATE (as has been done in original post) will ensure that blank values are returned for any [Title] that is not "Material Inspections"

Using MAXX(FILTER( ), Mer[Month]) will also ensure that blank values are returned for any Title that does not meet the filter conditions.

Using CALCULATE without the FILTER (so simply using BOOLEAN expression as you suggested) will return the same value of Material Inspection, even when we ask for a different Title.

If I understand the original post correctly, the question, copied below, was about number formatting, not blank values returned.

We will have to wait for @kannanAhammed to provide more clarity around the problem, but I have assumed that they are happy with the blank values (particularly as they are converted to zero within the DAX function) and only wanted help with the formatting, not in replacing those blank values with material inspections.

"MER'[This month]" will have values such as "0.775193798" once converted to percentage it will be "77.53%". i would like to remove the decimal and have the output to "77%".

[AllisonKennedy]

I would recommend keeping the measure as a number, so do NOT use the DAX FORMAT() as that converts to text

https://docs.microsoft.com/en-us/dax/format-function-dax

Instead, just use the measure formatting:
https://radacad.com/custom-format-fields-and-measures-in-power-bi