Percentage measure for MutliRow Card - Format as percentage

[AJA21]

Hi

I created a measure to return a percentage of total fees billed by sub-category in my report

Percentage = DIVIDE(CALCULATE(SUM('Query 1' [Fees]), ALLSELECTED('Query 1'[Sub Category])),CALCULATE(SUM('Query 1'[Fees])))

It works perfectly except it's not formatted as a percentage.

For example it comes out as 6.87, I would like it to show 6.87%, if I use the format option in measure tools and select percentage it comes back as 687%

How do I get this to format properly?

Thank you!!

[AJA21 · Accepted solution]

I figured it out, I needed to divide by 100 and then format to percentage in measure tools, see below

Percentage = DIVIDE(CALCULATE(SUM('Query 1' [Fees]), ALLSELECTED('Query 1'[Sub Category])),CALCULATE(SUM('Query 1'[Fees])))/100

[qqqqqwwwweeerrr]

Hi @AJA21 

you can do this by create this measure

Percentage =
                    VAR TotalFees = CALCULATE(SUM('Query 1'[Fees]))
                     VAR SubCategoryFees = CALCULATE(SUM('Query 1'[Fees]), ALLSELECTED('Query 1'[Sub Category]))
RETURN
                       FORMAT(DIVIDE(SubCategoryFees, TotalFees) * 100, "0.00%")

Did I answer your question? if not please more details about data and problem statment
Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards

[AJA21]

The data is a set of dollar amounts, formatted as currency, I have multiple Query's in this report but this formula is only referencing one of those Query's, I haven't had any problems with other visualisations or summarisations of this data so I don't think it's an underlying issue with the data set. 

I'm not sure what else is useful to know. Let me know if there is other information that would help.

Thanks

[AJA21]

Hi,

No unfortunately, using the same example above, this came back as 61823.65%.

Cheers