Forum Discussion
Measure Issue - Parameter related - or relationship between data sources issue?
I have a perfectly functional table, who's filters work very well. The issue starts when I create a relationship between my main data source, and another source which is a combined list of various conferences throughout the year and the attending company's unique ID. When I add the conference name slicer to the table, I should technically be able to select the conference name and the data filter to only show those companies attending that conference...that is not the case.
I did notice that when I restructured the table, i left out the measure that adds up the score for the different paraments, when leaving that measure out, the table works perfectly fine. I don't know how to bring it all together since it seems my data sources aren't fully syncing well.
I need your help. Any guidance or insight is highly appreciated.
Hi Neyney ,
In your data model, you may need to create another bridged table of ID and Name, filtering first through the ID to the Name of the bridged table, and finally joining with the Name of the fact table, with the direction of filtering depending on your specific needs. You can refer to the documentation for a simple example:Many-to-many relationship guidance - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi Neyney ,
Measure is based on context. Can you provide a sample mapping of your data model and the expected results?
Best regards,
Community Support Team_ Scott ChangHi Scott, after further research it seems the issue is the relationship. I am creating a relationship, but it's only allowing me to do a many to many relationship, when i need it to be a many to one. It seems I need to create a bridge table? I am not very familiar with that. Here is a sample mapping:
The objective is to incorporate a slicer with a dropdown option for conference names, sourced from the List of active registrantss. The table, derived from the CUTT data source, will include this new filter. By selecting different conferences from the dropdown, the table will dynamically sort and display only the attendees from the chosen conferences. That is the goal.
Hi Neyney ,
In your data model, you may need to create another bridged table of ID and Name, filtering first through the ID to the Name of the bridged table, and finally joining with the Name of the fact table, with the direction of filtering depending on your specific needs. You can refer to the documentation for a simple example:Many-to-many relationship guidance - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
