Forum Discussion

nicolast29's avatar
nicolast29
Helper V
2 years ago
Solved

dax relation data model

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