power bi report help please

[mrben100]

Hi

I am trying to make equipments availability report for certain date from 2 tables linked together by specific date say for example (03/03/2019)

that date return to the jobs that we did in some equipments. When i run the report i got only the equipments that have jobs

on that day but i neeb my report to show all the equipments even those has no job on that day because those equipments without

job are working and i want to show that they have 100% availability .

this what i got from the report

and this what i need to show all of my equipments

( in Access it is easy by editing the relathionship properties and chose keep all records from first table)

Thanks

waiting for help please

[v-shex-msft · Accepted solution]

Hi @mrben100 ,

You can consider extract date value to create a bridge table to link two tables, then you can choose single direction relationship to let it keep all records.

HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

Regards,

Xioaxin Sheng

[v-shex-msft · Accepted solution]

Hi @mrben100 ,

You can consider extract date value to create a bridge table to link two tables, then you can choose single direction relationship to let it keep all records.

HOW TO JOIN MANY TO MANY WITH A BRIDGE TABLE IN POWER BI

Regards,

Xioaxin Sheng

[mrben100]

thanks for your response

but the dates are in only one table the (job_code) is the relation between the tables if i want to extract a column to be a bridge

is the job_code.

[v-shex-msft · Accepted solution]

Hi @mrben100 ,

Have you consider to break relationships and write a measure to achieve filter effect?

Applying a measure filter in Power BI

Regards,

Xiaoxin Sheng

[mrben100]

waiting for help please