My average rate is showing more than 100%

[divyaraj1407]

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?

[v-saisrao-msft]

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.

[sanalytics · Accepted solution]

@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

[divyaraj1407]

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,

[v-saisrao-msft]

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.

[v-saisrao-msft]

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.

[Deku]

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