Forum Discussion
Measure Issue - Parameter related - or relationship between data sources issue?
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.
Hi 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 Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.