Individual percentage for each row, based on columns from two different tables

[OzzB77-]

Hi.

I have been trying to calcualte percentage of each row in table O, based on a row values from table P. They are both connected to a calendar for weekend date, plus to each other with through ID (not active relationship, one to many). I have tried measures, one works works for total percentage but not for individual rows.

FillRate = (SUM(PlacementsFromTimesheet[Placements])/SUM(OpeningFromJob[Openings]))*100

I have tried divide, selectedvalue, etc nothing works for me.

I need something like (Table P [Placements]/TableO [Openings])*100 for each row.

Some Id's would be present in Table O but not in Table P, same for the weekend date, they will be NULL.

Need Help.

Thanks.

@amitchandak @Ahmedx 

[OzzB77-]

@amitchandak Sorry to bother you again, is there a way that I can put zero against the empty/Null fields that are coming though. As selecting from common table gives Placements and Openings from each table but against id's in Table O, there is no value in Table P. So it shows empty and skews the average. If it could be replaced with zero it would be accurate.

[amitchandak · Accepted solution]

@OzzB77- , For that you have to create common ID and Date/Weekend tables and join them back with both tables, and use them in Visual

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

[OzzB77-]

Hi @amitchandak ,

I added a common table for Id and it worked. Thanks for your help.

OzzB77