Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
nbs33
Helper II
Helper II

Filter Measure Not Working Properly

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:

nbs33_0-1644694225933.png

        nbs33_1-1644694287060.png

 

 

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 )

 

 

1 ACCEPTED SOLUTION

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. 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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?

yingyinr_1-1644893485301.png

Best Regards

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. 

nbs33
Helper II
Helper II

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.

 

nbs33_1-1644696478779.png

 

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.