topic Re: DAX | Two slicers aren't working in my PBI Table in DAX Commands and Tips

DAX | Two slicers aren't working in my PBI Table

Anonymous — Sun, 23 Jan 2022 14:49:59 GMT

Hello guys,

I'm facing some difficulties with my PBI. There are two slicers that are not working: Fullfilment and PO Type

Product table has three calculated columns : Stock Max Date, days available stock and average items sold and is connected

to stock(1-Many) and Sales(1-Many). Sales and Stock aren't directly connected.

I have a table with two slicers: Fullfilment Type and PO Type

The table has two features: Country Code and Items sold.

Whenever i filter by Fullfilment Type and PO type, it doesn't matter, the values won't change.

Do you have any tips for this issue?

Attached you can find excel file with the tables and relationship between them

FILE With the settings

Thanks a lot

Diego

Re: DAX | Two slicers aren't working in my PBI Table

amitchandak — Mon, 24 Jan 2022 03:59:36 GMT

Anonymous , if Fulfillment Type and PO Type belong to product table it should filter unless interaction or measure stops it

Re: DAX | Two slicers aren't working in my PBI Table

Anonymous — Mon, 24 Jan 2022 08:16:36 GMT

The fact that i'm using calculated columns in product table could be the reason behind it ? And if yes, i have to pass them inside a measurr variable ?

Thanks

Re: DAX | Two slicers aren't working in my PBI Table

v-zhangti — Fri, 28 Jan 2022 07:27:18 GMT

Hi, Anonymous

Can you provide a simple PBIX file for testing? I can't restore the data for testing because I don't know the format of the fields in your table. You can provide some of the test data according to your needs, and sensitive data can be removed in advance. Looking forward to your reply.

Best Regards,

Community Support Team _Charlotte

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

Re: DAX | Two slicers aren't working in my PBI Table

Anonymous — Sat, 29 Jan 2022 11:26:07 GMT

Hi v-zhangti

Here it is, there are not all connections but I believe the enough to see whats going on. Basically if I change on my slicer settings the PO type and fulfillment I cannot see changes on the table.

Sample

Thanks

Diego