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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.