How to change to percentage of tenths

[Syndicate_Admin]

Hello good day.

I have a measure in which I have the "percentage" that gives me from some tables, but I want that instead of giving me "9000", I want it to give me the value from 0 to 100.

That is, have the value of 90.8% percent instead of 9004

[v-henryk-mstf · Accepted solution]

Hi @Syndicate_Admin ,

According to your description, first of all, if there is an error in the calculation logic of the created formula, it may cause the value of the percentage to exceed 100%.

Otherwise, just divide the original formula by 100.

Filter_Blank =
(
    CALCULATE (
        [Amount_],
        DimProduct[Color] = "Black",
        DimProduct[ModelName] = "Mountain-200"
    ) / [Amount_]
) / 100

If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[VahidDM]

Hi @Syndicate_Admin 

Create a measure and Divide that number by 100

Measure = [value]/100

then change the measure format to percentage and use that in your report.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube