Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
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.
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.
That work!!! Tks so much (:
Hi there,
Yes, you can do the same in Power BI, just drag the values into:
for exemple =>
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%
User | Count |
---|---|
22 | |
19 | |
12 | |
10 | |
10 |
User | Count |
---|---|
31 | |
25 | |
15 | |
13 | |
12 |