Forum Discussion
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
thanks for helping
Nicolas
This appears to be the result of table expansion.
Here is an article that helps to describe what you are seeing.
2 Replies
- jgeddesSuper User
This appears to be the result of table expansion.
Here is an article that helps to describe what you are seeing.
- nicolast29Helper V
Hi
thanks a lot
I read it in the past but forgot it
Now it is clear
Have a nice day