Different filters on the same visual

Question

Hey All!
&nbsp;
I have a table where each column should be filtered differentlyFor example column A will get the following filter: working, Forecast, 5 sitescolumn 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!
&nbsp;
&nbsp;
&nbsp;

fowmy · Answer

netanel&nbsp;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 · Answer

Hey&nbsp;Fowmy&nbsp;
&nbsp;

Calculatetable is Good butt&nbsp;Product is DIM 1
I have more Diminsion

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

fowmy · Answer

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

netanel · Answer

Fowmy&nbsp;
Yes, sorry it really is not understood enoughAttach a picture that will explain moreIn the picture I have a table of PNLThe table has two columnsIn each column I have different filters from a different DIMSo if product is DIM 1 then I have more filters from DIM 2 and DIM 3Link to file:&nbsp;https://1drv.ms/f/s!AonyYI-TdspHgltwngZ6OKvpnSsc

Forum Discussion

Different filters on the same visual

4 Replies

Related content

Page Level filter for different groups

Filtering Multiple Visuals with Different Filter Criteria

Date filters for Visualization

Visualizations with different filters

Filters issues in visual objects