topic Re: IsFiltered returning true at row level when no filter has been applied in DAX Commands and Tips

IsFiltered returning true at row level when no filter has been applied

C4L84 — Tue, 18 Jan 2022 17:10:28 GMT

I have a page with the following:

Measure =

VAR Previous_Month = CALCULATE(MAX('Month Order'[Month]),FILTER('Month Order','Month Order'[Previous month] = 1))

RETURN

IF(ISFILTERED('Month Order'[Month]),

IF(MAX('Month Order'[Month]) = Previous_Month, 1, 0)

)

Why is the isfiltered returning true at a row level in the table when there no filter has been applied?

Re: IsFiltered returning true at row level when no filter has been applied

ValtteriN — Tue, 18 Jan 2022 17:56:24 GMT

Hi,

DAX works in the context it is placed and in the case of your table when you place the measure next to a month column ISFILTERED is tested in that context e.g. if it is next to APRIL the filter context is 'Month Order'[Month]= 'April' and thus it is indeed filtered from ISFILTERED perspective. To counter this you can have separate column for filtering and for visuals.

e.g. Here I am testing if [date] ISFILTERED:

When using the [Date] column the visual return TRUE

With [DateF] it return FALSE

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

Re: IsFiltered returning true at row level when no filter has been applied

C4L84 — Wed, 19 Jan 2022 09:26:27 GMT

Hi ValtteriN,

Thank you for explaining the row level context.

My idea is to create a measure that checks if the page has been filtered, if true then show selected value, else show previous month as default. To do this I wanted to use a measure in the visual filter:

The table that I was using was to test the logic but now I understand it cannot be tested like that.

Do you know how I can apply a filter that defaults a visual to the previous month unless a filter selection has been made?

Thanks again.

Re: IsFiltered returning true at row level when no filter has been applied

Anonymous — Fri, 21 Jan 2022 08:35:44 GMT

Hi C4L84 ,

I suggest you to create an unrelated Month table for Slicer and then create a measure to filter your visual.

My Sample:

Create an unrelated Date table.

Date = ADDCOLUMNS ( CALENDAR ( DATE ( 2021, 11, 01 ), DATE ( 2022, 01, 31 ) ), "Year", YEAR ( [Date] ), "Month", MONTH ( [Date] ), "YearMonth", YEAR ( [Date] ) * 100 + MONTH ( [Date] ) )

Create a measure.

Measure = VAR _SELECTVALUE = SELECTEDVALUE('Date'[YearMonth]) VAR _TODAYYEARMONTH = YEAR(TODAY())*100+MONTH(TODAY()) VAR _PREVIOUSYEARMONYH = MAXX(FILTER(ALL('Date'),'Date'[YearMonth]<_TODAYYEARMONTH),'Date'[YearMonth]) RETURN IF(ISFILTERED('Date'[YearMonth]),IF(MAX('Table'[YearMonth]) = _SELECTVALUE,1,0),IF(MAX('Table'[YearMonth]) = _PREVIOUSYEARMONYH,1,0))

Add this measure into visual level filter and set it show items when value =1. Result is as below.

By default, it will show previous data.

Select 202111.

Best Regards,
Rico Zhou

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