topic Re: My average rate is showing more than 100% in DAX Commands and Tips

My average rate is showing more than 100%

divyaraj1407 — Wed, 23 Apr 2025 07:17:04 GMT

This is my DAX, but not sure why it is showing more than 100% when I'm trying calculate my average rate.

Avg Utilisation Rate =

(DIVIDE(SUM('Office Utilisations'[Seat Utilisation]),

SUM('Total Seating Capacity'[Current Seat Count]))) * 100

I used this one too,

Avg Utilisation Rate = (DIVIDE(SUM('Office Utilisations'[Seat Utilisation]), 'Office Utilisations'[Date count])) * 0.01

Please help?

Re: My average rate is showing more than 100%

Deku — Wed, 23 Apr 2025 07:20:21 GMT

Assume this is related to your data. Confirm the numerator is less than your demoninator.

You can debug by creating measures for both numerator and denominator and visualing in a table

Re: My average rate is showing more than 100%

divyaraj1407 — Wed, 23 Apr 2025 07:42:28 GMT

I'm using this at the moment, I'm bit new to power Bi

Avg Utilisation Rate = (DIVIDE(SUM('Office Utilisations'[Seat Utilisation]), 'Office Utilisations'[Date count])) * 0.01

however, when I have something like below instead of calculating for 100%. This is the simple calculation I'm trying,

Re: My average rate is showing more than 100%

sanalytics — Wed, 23 Apr 2025 08:07:58 GMT

divyaraj1407
Instead of doing straight SUM can you wrap your formula with an iterator.. See the below code works for you or not.. If not, i suugest you to provide your pbix file with dummy data so that we can check from our end.

AVERAGEX( VALUES('Office Utilisations'[Date]), DIVIDE( SUM('Office Utilisations'[Seat Utilisation]), SUM('Total Seating Capacity'[Current Seat Count]) ) ) * 100

Hope it helps.

Regards

sanalytics

Re: My average rate is showing more than 100%

v-saisrao-msft — Mon, 28 Apr 2025 07:13:38 GMT

Hi divyaraj1407,
I wanted to check if you had the opportunity to review the information provided by sanalytics. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

Re: My average rate is showing more than 100%

v-saisrao-msft — Thu, 01 May 2025 12:11:04 GMT

Hi divyaraj1407,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Re: My average rate is showing more than 100%

v-saisrao-msft — Mon, 05 May 2025 04:19:43 GMT

Hi divyaraj1407,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.