A DAX measure to ignore specific Filter.

[Ritesh_Air]

Hi,

I am trying to ignore a filter in a visual. Here is the problem statement:

I have a measure called "Gross Sales Forecast" and filter called "Workday Indicator", which filters weekend dates.
In my visual, I want to ignore this filter for just this one measure. There are other measures in the visuals as well, they should work as expected.

So for e.g.: even if the filter of Workday Indicator being 1, "Gross Sales Forecast" should show 350.

Gross Sales Forecast	Work Day Indicator
100	0
250	1

I tried this with no luck.

GSF New =
CALCULATE (
    SUM ( 'BU Performance - Daily'[Gross Sales Forecast] ),
    ALL ( 'Date'[Workday Indicator] )
)

Thanks,

Ritesh

@parry2k 

@mahoneypat 

[parry2k]

@Ritesh_Air what you currently doing is not working? 

[Ritesh_Air]

@parry2k 

I should mention, On the X axis, we have "Executive Segment". A and B.

This is with Work Indicator being 0 coming as 145M

I was hoping it to be aggregation of both Work Indicator 0 and 1. 

I have tried this as well to test. This ignores Executive Segment, but I don't want to ignore "Executive Segment". Only want to ignore "Workday Indicator"

GSF New =
CALCULATE (
    SUM ( 'BU Performance - Daily'[Gross Sales Forecast] ),
    ALL ( 'Date'[Workday Indicator] ),
    ALL ( 'Product'[Executive Segment] )
)

Thanks,

Ritesh

[amitchandak · Accepted solution]

@Ritesh_Air , That all workday might not work.  Try like, this will ignore workday filter but add date filter

GSF New =
var _min = minx(allselected('Date'),'Date'[Date])
var _min1 = minx(allselected('Date'),'Date'[Date])
CALCULATE (
    SUM ( 'BU Performance - Daily'[Gross Sales Forecast] ),
     filter(all(Date),Date[Date]<=_max && Date[Date]>=_min)
)

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Ritesh_Air]

Thanks Amit. It worked.

@amitchandakIf I have to document what that piece of code is doing then can you verbose it?

Thanks,

Ritesh

[amitchandak]

@Ritesh_Air , we are removing all the date filter by using all on date table and pushing back required filters