Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Store dynamic values based on filter selection

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

 

2 Replies