Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Divide to find out the % and ranking

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%

percentual by client.PNG

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

% per client.PNG

It's possible?

 

Tks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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.

Anonymous
Not applicable

That work!!! Tks so much (:

Anonymous
Not applicable

Hi there,

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

for exemple => Screenshot 2019-08-07 at 20.54.13.png

 

Have a nice day,

Chen

Anonymous
Not applicable

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%

 

 

Anonymous
Not applicable

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

Best
Darek

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!