Using different string formatting in specific rows in Matrix

[Anonymous]

My matrix roughly looks like this: 

KPI	Unit1	Unit2	Unit3
KPI1	0.2%	0.4%	0.6%
KPI2	0.3%	0.5%	0.7%
KPI3	2.0%	3.0%	4.0%

I need KPI2's units to be in pp format. so in this case, KPI2:Unit1 should read 0.3pp and all the same for the other units; but it should stay the same for the other KPIs. The data is all in one table, and must be the same order as above. 

The resulting matrix visual that I'm looking for would roughly look like this: 

KPI	Unit1	Unit2	Unit3
KPI1	0.2%	0.4%	0.6%
KPI2	0.3pp	0.5pp	0.7pp
KPI3	2.0%	3.0%	4.0%

Any help would be appreciated.

[NaveenGandhi · Accepted solution]

Hi @Anonymous 

Pleasue use below DAX.

Unit1 % =

Var unit = DIVIDE(sum('Table'[Unit1]),CALCULATE(sum('Table'[Unit1]),ALL('Table')))

RETURN if(SELECTEDVALUE('Table'[KPI])="KPI2",FORMAT(unit,"0.0"&"pp"),FORMAT(unit,"Percent"))

Let me know if thist helps.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!