Forum Discussion

gthistlethwaite's avatar
gthistlethwaite
Frequent Visitor
8 years ago

Calculating Ratios

Hi,

 

I have been trying to calculate ratios in Power BI Desktop, but so far I am unable to fathom how to do it.

 

My requirement is, I need to count the number of events in a column, then divide this by the sum of all numbers from another column in a different table, and then multiply this by a factor of 100000.

 

Table 1 = All 'Events'

Table 2 = All 'Worked Hours'

Table 3 = Locations

Relationship is set = locationID in events table matches with locationID in Location Table // locationID in Location Table is linked to locationID in events table.

 

How may this be achieved?

 

Many thanks for anybody able to support.

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi gthistlethwaite,

     

    Please post sample data of three tables and make the relationships between them more clear.

     

    "then divide this by the sum of all numbers from another column in a different table"

    Which column in which table should be summed up?

     

    Please show us your desired result with examples.

     

    Regards,

    Yuliana Gu