topic Re: Filter Measure Not Working Properly in Developer

Filter Measure Not Working Properly

nbs33 — Sat, 12 Feb 2022 19:39:55 GMT

Hi,

I have created a measure that uses a parameter to filter a matrix. Here is the orginal post were I got the help to create this measure.

There is also a simplified model in the post that functions perfectly.

When I apply this measure to my model it does not work and I can't seem to figure out why. Without a year selected it will filter but not correctly. As can be see in the image below, the slicer max value is 64.09% but the matrix shows values of 65.19%. Even more strange when a year is selected it doesn't filter at all.

I thought it might be related to the blank in my year slicer. I tried to remove this blank by removeing all blank dates in tables related to my date table but the blank remains. Other than that I am not sure what to do.

I am truely stuck. My hypothsis at this point is that there is some complexity in my model that is causing this issue. Any ideas are greatly appreciated.

No Year Selected: Year Selected:

Filter Measure:

InSelectedRange = VAR Level1Growth = CALCULATE ( [YTD vs PYTD Revenue %], ALLSELECTED (), VALUES ( Companies[Level 1] ), VALUES( Dates[Year] ) ) VAR RangeBuckets = FILTER ( Range, Range[Range] <= Level1Growth && ( Range[Range] = 1 || Range[Range] + 0.1 > Level1Growth ) ) RETURN IF ( ISEMPTY ( RangeBuckets ), 0, 1 )

Re: Filter Measure Not Working Properly

nbs33 — Sat, 12 Feb 2022 20:10:12 GMT

I deleted the relationship between my date table and my Append CRM Data table and the my measure filters when a year is selected. I think this is related to an overly complex data model.

But I'm still not sure why my matrix is returning values slightly greater than my max threshold value in my range slicer.

Re: Filter Measure Not Working Properly

Anonymous — Tue, 15 Feb 2022 02:54:09 GMT

Hi @nbs33 ，

Could you please share your sample pbix file with latest version with us in order to make troubleshooting and provide you a suitable solution? Which field be used on the Range Slicer? Or it is from what-if parameter?

Best Regards

Re: Filter Measure Not Working Properly

nbs33 — Tue, 15 Feb 2022 14:34:47 GMT

Thank you @Anonymous, I just figure it out. my measure was computing the range value in 10% increments which is why I was getting strange values. I just changed the slicer to a drop down so the selection will bucket the results in these 10% increments and make more sense to the user.