how to filter the data of a segment with only the data that corresponds to it

[Cobra77]

hi 

how to filter the data of a segment with only the data that corresponds to it ?

We want to filter the values of the subcontractor segment with only those who have data in the fact tables hours or accident for a filtered project

sample : 

its an example , we have multiple fact tables and another dimensions

it is possible ?

thanks.

[v-frfei-msft]

Hi @Cobra77,

Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.

Regards,

Frank

[Cobra77]

hi @v-frfei-msft

the sample data :

https://1drv.ms/f/s!AGluE3Tt6h4Weg

Only 4 subcontrators on the dropdown list for the project 8 filter

thanks for your help.

Best regards