cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marocha
Frequent Visitor

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.

View solution in original post

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

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors