topic Re: Divide to find out the % and ranking in DAX Commands and Tips

Divide to find out the % and ranking

Anonymous — Wed, 07 Aug 2019 17:18:36 GMT

Hello,

I'm new on dax, and need some help.

I wanna DIVIDE "total do valor de utilização"/"Valor limite de crédito" to know how much (%) represents, but i wanna do per client, so, for example: 53.267/39.000 = 136%

And after find out the % per client, I wanna make a ranking, in Excel it's like that:

It's possible?

Tks

Re: Divide to find out the % and ranking

Anonymous — Wed, 07 Aug 2019 18:56:17 GMT

Hi there,

Yes, you can do the same in Power BI, just drag the values into:

for exemple =>

Have a nice day,

Chen

Re: Divide to find out the % and ranking

Anonymous — Thu, 08 Aug 2019 18:33:37 GMT

Tks, I will try this one, but first i have to do the measure, do you have any idea about what measure can i use to I DIVIDE "total do valor de utilização"/"Valor limite de crédito" to know how much (%) represents, and i wanna do per client, so, for example: 53.267/39.000 = 136%

Re: Divide to find out the % and ranking

Anonymous — Thu, 08 Aug 2019 23:10:38 GMT

What are these: "total do valor de utilização" and "Valor limite de crédito"? Are they measures?

Best
Darek

Re: Divide to find out the % and ranking

Anonymous — Fri, 09 Aug 2019 07:51:30 GMT

Hi there,

Yes, you can do measure:

%total = DIVIDE ( sum('Table'[Total do valor de utilizaçao]) ; sum('Table'[Valor limite de crédito]) )

and you drag this measure to one graphic as value, and then you put the "Client" in the same graphic as X or Y axe.

Hope this would be helpful.

Re: Divide to find out the % and ranking

Anonymous — Fri, 09 Aug 2019 20:57:15 GMT

That work!!! Tks so much (: