- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Compare table results
Hello All, I need some help with some results that I am getting on one of my dashboards.
What I need is to get the ratio between the two numbers, however, when I do the calculations the results are not correct, for instance:
Earn hours:
Paid hours:
Ratio calculated by Power BI using DIVIDE formula:
Nov 15: 13.15 / 10.28 = 8.16%
Nov 16: 10.68 / 10.57 = 6.63%
Nov 17: 3.32 / 8.55 = 2.06%
Nov21: 2.95 / 10.25 = 1.83%
Ratio calculated by Power BI using that I currently have:
Nov 15: 13.15 / 10.28 = 179.47%
Nov 16: 10.68 / 10.57 = 145.82%
Nov 17: 3.32 / 8.55 = 45.32%
Nov21: 2.95 / 10.25 = 40.29%
The result of this formula is a little bit closer but it is still off.
The results that I am expecting are:
Nov 15: 13.15 / 10.28 = 127.9%
Nov 16: 10.68 / 10.57 = 101%
Nov 17: 3.32 / 8.55 = 38.8%
Nov21: 2.95 / 10.25 = 28.78%
The summaries in the tables "Earn hours" and "Paid hours" are correct, however, as you can see the calculations are incorrect.
Please let me know if this information is enough, the model comes from a huge database so I complicated to share a usefull model.
Thanks in advance for your help.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ Johel_D
Based on your question, I have created the following two tables
Then you need to create a relationship for the two tables in the Model View
Then you can use your formula to get the results you want
Measure =
DIVIDE(
SUM('Earn hours'[Earn Hours]),
SUM('Paid hours'[Hours])
)
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @ Johel_D
Based on your question, I have created the following two tables
Then you need to create a relationship for the two tables in the Model View
Then you can use your formula to get the results you want
Measure =
DIVIDE(
SUM('Earn hours'[Earn Hours]),
SUM('Paid hours'[Hours])
)
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
07-22-2024 08:36 PM | |||
03-24-2024 09:14 PM | |||
06-18-2024 07:31 AM | |||
01-16-2024 01:26 AM | |||
06-21-2024 09:03 AM |
User | Count |
---|---|
23 | |
12 | |
10 | |
10 | |
8 |
User | Count |
---|---|
16 | |
15 | |
15 | |
12 | |
10 |