Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin 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.
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 )
Solved! Go to 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.
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
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.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
8 | |
7 | |
2 | |
2 | |
2 |
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
4 |