topic Re: how can i add % in matrix in DAX Commands and Tips

how can i add % in matrix

vilden — Tue, 29 Nov 2022 10:23:51 GMT

Hello, i have matrix like this and i need to calculate it in % too, now it is just calculated like

Početnosť = DISTINCTCOUNT(KP[K_PODPROD]).

Summary need to be 100%, how can i transform it to %??

BITomS — Tue, 29 Nov 2022 10:45:49 GMT

Sounds like you need to create some new measures using the DIVIDE expression:

Measure = DIVIDE([Numerator],[Denominator])

vilden — Tue, 29 Nov 2022 11:17:32 GMT

Doesnt work.

Anonymous — Wed, 30 Nov 2022 07:14:09 GMT

You can through the following ways to change it to % format:

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly