Store dynamic values based on filter selection

[Anonymous]

Hi All,

I am stucked in a problem of converting one of the dynamic filter from SQL procedure to power bi

I have Billing Type filter which has following values

My filter will use TypeDescr as a selection and I need to check BillingType value into my fact table

The problem is a many to many relationships as there are two records for Billing in DimProcess

So When the filter have All selected by default it needs to be check Billing one time only 

What I want to achieve is 

When a user selects 1st of the month or 15th of the month, I want to check Billing into fact table

When a user selects Flexible then I want to check FLEXDDBILL 

And as it is All by default I want to check for Billing and FLEXDDBILL.

This is how I had in the Stored procedure 

Any help must be appreciated.

Thanks

[v-angzheng-msft]

Hi, @Anonymous 

Here are some references that may help you

Many-to-many relationship guidance 

Filtering on many to many relationship 
Apply many-many relationships in Power BI Desktop 

Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified 

It’s Complicated – Dealing with Many to Many Relationships in Power BI 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I have added a bridge table between both tables causing many to many relationship this works for me. thanks