Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nicolast29
Helper V
Helper V

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

nicolast29_0-1716508025170.png

 

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 😂

nicolast29_0-1716508817127.png

 

 

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

1 ACCEPTED SOLUTION
jgeddes
Super User
Super User

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/ 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
nicolast29
Helper V
Helper V

Hi

thanks a lot

I  read it in the past but forgot it 

Now it is clear

Have a nice day

jgeddes
Super User
Super User

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/ 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.