Need help : How to show 2 different measures in one column

[Anonymous]

Hi Community, 

I have been trying to bring 2 different measures in matrix visual into one column as shown in screen shot below. Kindly assist . 

Actual : 

Expected : 0.44%(8) 

                  3.97%(186) 

                  4.71%(227) 

Thanks,

G Venkatesh 

[Anonymous]

Hi @Anonymous,
You can do this by creating a new measure and placing it in the matrix.

The formula for the measure is:

Concat_Measure = [Forecast] & "(" & [Running Total Forecast] & ")"

If this works fro you, please mark it as a solution!

Thank You.

[Anonymous]

Thanks Mate. It worked . 

[PaulDBrown · Accepted solution]

@Anonymous 

Try:

Concatenate = FORMAT([Forecast], "#0.00%") & " (" & FORMAT([Running total forecast], "Standard") & ")"