Use Two Calculation Groups in Matrix + Format String Expression

[Anonymous]

Hi everyone !

I wanted to ask you if anyone has worked with 2 groups calculated in a matrix.

The problem I have is regarding the format of the values, since according to which calculated item is selected, I use the format of the first or second calculated group.

Example:

In the following matrix I need the last column to show me the values in percentage format.
But I have two groups calculated and it always selects the format of the first group.

First calculated group where the calculated item has the format "€, 0.0":

Second calculated group where the calculated item has the format "0.00%":

I need to select the format of the first one, but in the last column I need to take the percentage value, is it possible?

Thanks!

Regards!

[Anonymous]

@Anonymous 
1. You may change the format in the top menu. 

2. create another measure to replace the old field using format() function. 

FORMAT( sum[variance], "Percent") 

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.
  

[Anonymous · Accepted solution]

I was able to solve it, the problem was in the precedence of Tabular Editor. Thank you!