Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to explore a nomenclature


I'm french so sorry if it's not clear 😉

I have 2 questions on the same topic. I'm sorry but I am not allowed to send the dataset.


1 - I'm trying to find a better solution to explore 2 basis containing a nomenclature (1st component and 2nd the assemblies)

      Here is an example of what I did

            I duplicatate my basis 7 time to have my 7 level (which are not used in all cases)

            I also add each time a table with only Item_Code to avoid a many to many relation

            Assemblies level1 -- Bill_Item_code --> Component level1

            Component ---------ItemCodeSite----> ItemCode 

            ItemCode------------ItemCode--------> Assemblies level2

            and so one

            It works but it's heavy .


2 - If I select one table at a time I have a good filter behaviour BUT when I try to Union this differents tables it didn't filter anymore



I really hope someone can help me

Take care



Community Support
Community Support

Hi @Yannick63 ,


This is unnecessary and will increase the size and complexity of the model.
PowerBI supports many-to-many relationships. You can directly establish many-to-many relationships and create measures to complete the calculation logic.


Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources



We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors