Different filters on the same visual

[netanel]

Hey All!

I have a table where each column should be filtered differently
For example
column A will get the following filter: working, Forecast, 5 sites
column B will get the following filter: Ready, Forecast, 10 sites

Which DAX can I use?
Is there another better option than DAX?

I would appreciate your assistance!

[Fowmy]

@netanel 

Since you are trying filter on the same table but different columns, the records that get satisfied by filter will be returned. Please check the example below:

CALCULATETABLE (
    'Product',
    'Product'[Color] IN {"Blue","Purple"},
    'Product'[Brand] IN {"Contoso","Fabricam"}
)

[netanel]

Hey @Fowmy 

Calculatetable is Good butt Product is DIM 1

I have more Diminsion

Is it possible to make another DIM on the same Measure?

[Fowmy]

@netanel 

Sorry, could you expalin with some data along with the expected results to better understand your question ?

[netanel]

@Fowmy 

Yes, sorry it really is not understood enough
Attach a picture that will explain more
In the picture I have a table of PNL
The table has two columns
In each column I have different filters from a different DIM
So if product is DIM 1 then I have more filters from DIM 2 and DIM 3
Link to file: https://1drv.ms/f/s!AonyYI-TdspHgltwngZ6OKvpnSsc