Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have the below data for calculation.
I am stuck at a place to get the number of units for the calculation of average call rate.
Let me know if I could explain in detail
I have put the pbix file here.
I wanted the below calculation
From Unit Details -
In Unit Details Table - In Unit 1 - How many Units are there as per Job ID - That Gives No. of Unit in one Premise
In Call Details Table - In Unit 1 - How many calls have been logged totally over the months
Then I take Call Rate and I do not know how to calculate it
Also, I do not know how to calculate the average call rate
I have put the pbix file in the above link
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 17 | |
| 9 | |
| 8 | |
| 7 |