Forum Discussion
Why is this filter/column not working?
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
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 TeamIf 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
1 Reply
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 TeamIf 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