KPI with Calculation & Text

[Pikachu-Power]

Hello,

in a Card it is possible to combine a CALCULATION(...) and TEXT. For example with CALACULATION(...) & " Volt". In a KPI it doesnt work. I get an empty field. Are there some workarounds?

Thanks.

[v-diye-msft · Accepted solution]

Hi @Pikachu-Power 

Kindly check below threads whether helps:

https://community.powerbi.com/t5/Desktop/Help-with-solution-for-multiple-criteria/td-p/1295834#

https://community.powerbi.com/t5/Desktop/Combine-Calculated-numerical-column-with-text-formatted-uni...

[Pragati11]

Hi @Pikachu-Power ,

Did you try using CONCATENATE function?

It will nice to see what calculation you are using. Add more details like screenshots here.

Thanks,

Pragati

[Pikachu-Power]

Nothing special CALCULATE(SUM(Table[Column])) & " Volt"

You cant move a TEXT in the Indicator field of a KPI.

Therefore CONCATENATE also dont work.