How to make slicer filter values in a table if there is no join b/w two tables?

Anonymous — Tue, 13 Apr 2021 18:37:48 GMT

When I select west, it should 11

I have a query. I created a week1_forecast column in ‘A’ table. What it does is, if the region is west, then moves the week_number to +2 and if it is other region it moves week_no to +1.

But, ‘Region’ slicer in the dashboard is from ‘B' table. There is no join b/w 'A' and 'B' tables. I tried to create join but all columns has many to many relation.

Now, how do I make the slicer filter the values in week_forecast column. Can you pls guide?

Here, for example, if i select 'West' then it should show 11 in week1 forecast column.

DAX I wrote:

WeekNo._Wk1_forecast = IF(('A '[Region])="West",WEEKNUM('Start_Date].[Date])+2,WEEKNUM('Start_Date].[Date])+1)

Re: How to make slicer filter values in a table if there is no join b/w two tables?

Anonymous — Wed, 14 Apr 2021 21:38:33 GMT

Anonymous

Very easy, actually. You create a measure that will return 1 for the rows you want to keep and 0 for the others. Then you use this measure in the Filter Pane of the visual.

topic How to make slicer filter values in a table if there is no join b/w two tables? in DAX Commands and Tips

How to make slicer filter values in a table if there is no join b/w two tables?

Re: How to make slicer filter values in a table if there is no join b/w two tables?