dax relation data model

[nicolast29]

hi

I'm missing something in the way of the filter in the model

I have a main fact table and a main dimension table link like that

In a matrix i push for the row 

Vue_Bilan_2 from the fact table 

and under Compte_PCG_2_complet from the  dimension table,

.... and miracle i have that i want, but without understanding 😂

For example for the fist part

Vue_Bilan_2 from the fact table = A11 - Immobilisations incorporelles

it retrieve only the good values in the dimension table,

20 - Immobilisations incorporelles

28 - Amortissements des immobilisations

but I thought I understood that the filter could not go up, so how can it not show all the values from Compte_PCG_2_complet  ....

Here a link to the pbix file

filter matrix.pbix

thanks for helping

Nicolas

[nicolast29]

Hi

thanks a lot

I  read it in the past but forgot it 

Now it is clear

Have a nice day

[jgeddes · Accepted solution]

This appears to be the result of table expansion. 

Here is an article that helps to describe what you are seeing.

https://www.sqlbi.com/articles/expanded-tables-in-dax/