topic Re: How can I make Count Filter a list, not a slider? in DAX Commands and Tips

How can I make Count Filter a list, not a slider?

JordanSchuld — Mon, 17 Jun 2024 17:15:37 GMT

I'm brand new and no pretty much nothing so bear with me.

So I made a measure to track how many times each job posting was in my data. As you can see I added that measure to a table and it works perfectly. I attached a screenshot of how that measure was made. I also made a filter so the table will only display jobs that have more than X amount in the Total Listings measure.I added a screenshot of how I did that.

2 things, first off, it doesn't work super well. Say I adjust the slider to be above 20 jobs, some with only 1 or 2 listings will still get through. Also, the main thing, I want the filter to have check boxes that say "20+", "30+", "40+", etc. I don't want it to be a Slider. How can I make the Count Filter work like that instead of a slider?

Re: How can I make Count Filter a list, not a slider?

lbendlin — Tue, 18 Jun 2024 01:32:48 GMT

Power BI does not support dynamic binning - you need to bring your own buckets (a disconnected table) to feed your slicer. Then use the measure to sense the value of the slicer (make sure it is single value select).

Re: How can I make Count Filter a list, not a slider?

Anonymous — Tue, 18 Jun 2024 09:38:56 GMT

Hi JordanSchuld ,

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the calculated column.

Count Listing = SWITCH( TRUE(), [Total listing] >= 40, "40+", [Total listing] >= 30, "30+", [Total listing] >= 20, "20+", "Under 20" )

3.Drag the column into the slicer visual.

Best Regards,

Wisdom Wu

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

Re: How can I make Count Filter a list, not a slider?

JordanSchuld — Tue, 18 Jun 2024 13:45:04 GMT

So I tried this, but it shows eveything as Under 20.
Here is my Count Listings:

And here is my table:

Not sure what I'm doing wrong, any insight?

Re: How can I make Count Filter a list, not a slider?

JordanSchuld — Tue, 18 Jun 2024 13:46:01 GMT

I'm going to be honest with you, this is jiberish to me lol. I'm so new to Power Bi it's not funny.

Re: How can I make Count Filter a list, not a slider?

lbendlin — Tue, 18 Jun 2024 14:09:11 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523