Forum Discussion

Johel_D's avatar
Johel_D
Frequent Visitor
2 years ago
Solved

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 a...
  • Anonymous's avatar
    Anonymous
    2 years ago

     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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

 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.