2 tables not filtered correctly by filter table

[Maria9292]

Hi everyone,

I need a chart that compares fact and target through time:

There are 2 tables: Target and Fact and 2 tables that connect them: Date table and Filter table with unique values. 

The chart shows correct values until any filter from the filter table is applied. Then this happens:

Alghoth in tha Target and the Fact tables the values are the same. It doesn't filter Target Table correctly.

This is how they are connected: 

What might be the issue here?

Thanks!

Maria

[amitchandak · Accepted solution]

@Maria9292 , the model seems fine, Join is active. So unless there is a data difference it can not happen.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[v-shex-msft · Accepted solution]

Hi @Maria9292,
According to your description and snapshot, I think it may relate to your relationship mappings.

Maybe you can try to create a bridge table with multiple column relationships to link fact and target table, then you can use this table fields to filter two table records.

Relationship in Power BI with Multiple Columns 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Maria9292 , the model seems fine, Join is active. So unless there is a data difference it can not happen.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.