% of Medicare Cases

[BaldAccountant]

I have a dynamic formula that calculates different measures such as charge per case, Net profit per case etc.

One calulation is % of cases which are medicare.  Since most of the calulations are numbers, not percentage, I had to format this calculation as a pcercentage.  When I try to calculate teh difference between two different versions of the dynamic formula using % of Medicare cases I get the following error

The formula for this is DF - DF2 = Value([dynamic formula]) - value([dynamic formula2])

I tried it with the value formulas and without [dynamic formula] - [dynamic formula2]

I cant share the file here because of HIPAA and I am hoping someone can help with this without the file.  I could set up a dummy file with dummy info, but that would take quite a while due to the complexity of the dynamic formulas.

[johnt75]

Change both dynamic formula measures so that they return numeric values, e.g. 0.15. Then set the format to be a %, with as many decimal places as you need. That way when you display the values in a visual they will show up as e.g. 15%, but you can still use the underlying numbers in other calculations.

[BaldAccountant]

Wont that change all of the calculations to show up as %?

[ryan_mayu · Accepted solution]

@BaldAccountant 

have you tried dynamics formatting?

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings?wt.mc_id=DP...

[BaldAccountant]

That works, thanks.

[ryan_mayu]

you are welcome

[johnt75]

As @ryan_mayu suggests, using dynamic format strings is the way to go. You can use DAX code in there so that you can use logic to determine which is the correct format string.