Matrix grouping did not work for different display format

[NewbiePBI916]

So here is the problem:
I have a matrix with different measures, some are in percentage, some are just the rate in 0 decimal places, some are the rate in 2 decimal places.

The matrix is used as there are sub-categories and we want it collaspable.

The rate is just numerator divided by denominator.

So the final measure rate, is done using format(rate,"0%") or other DAX conditions.

The problem is, while the numerator and denominator (all levels) and rates (sub-category level) are calculated accurately, the collapsed top level rate is inaccurate, because it is treated as "string"/"text" and it just pick first or last (after the format).

How to get around that so it is accurate at the collapsed top level?

Thank you in advanced.

[amitchandak]

@NewbiePBI916 , Not very clear. But dynamic formatting can help. In this case, you might have to use isinscope for each level

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.