Why is this filter/column not working?

[JordanSchuld]

I have data that is a bunch of job listings from different sites. In the table you can see I have multiple job listings. The column "Total Listings" count how many times that specific listing on the specific website was posted. You can see how I made it in photo 2. I want to make a filter to only show jobs that have been posted X amount of times. See photo 3 for how I have it set up. I feel like this should work, but as you can see in photo 1 every row is being shown as "Under 20". How can I fix this so there are different amount and I can make my filter. Right now the only option in the filter is "Under 20"

I'm brand new to Power BI so I may need more clarification than you would think lol.

Photo 1: Table

Photo 2: Total Listings - Count how many times the job was posted

Photo 3: Count Listing - Column to filter by how many times the job was posted

[Anonymous · Accepted solution]

Hi, @JordanSchuld 

You can try the following dax to solve the problem.

Count Listing = 
CALCULATE (
    IF (
        [Total Listings] >= 3,
        "3+",
        IF ( [Total Listings] >= 2, "2+", "Under 2" )
    )
)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum