- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Help with Filtering Dimensions
Hi,
I am trying to filter some data and I'm having a hard time getting there.
I have a staff survey data table as follows and this is for one question; we have 63 total question:
Category Count of Responses
Strongly Disagree 4
Disagree 4
Neutral 12
Agree 109
Strongly Agree 116
I have multiple slicers users can look at the data, by department, job role and month survey sent.
For each question, I need to have the result show zero if the counts are less than 5. So in the above scenario, it would look like this:
Category Count of Responses
Strongly Disagree 0
Disagree 0
Neutral 12
Agree 109
Strongly Agree 116
This would also change based on the slicer options that are chosen.
Can anyone help with this please?
Thank you for any ideas!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was able to get to the solution I was looking for after I reconstructed the database, so I am all set.
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
Please see the DAX for this and replace with response column.
Measure = IF(COUNT(financials[Segment])<5,0,COUNT(financials[Segment]))
I have used limit 10 in the images.
If this helps, Please mark this as a solution.
Kudos are good too.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@VasTg ,
Thank you for your reply; this is rendering all results as zero.
I neglected to say in my original message that the answer values range from 1 to 5 which is why all the results are coming up zero.
So for each question, I need the totals to be greater than 5 to show the number (taking into account the answer values are 1 through 5) and if they fall below zero to show zero; as well as if a slicer is chosen, for instance, department, and those numbers could be zero if the total for that question, based on the filter is less than 5.
Thank you again for your quick reply!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
Are you looking for count or sum? If sum, change the DAX to SUM.
If will be helpful if you provide a mock-up data with actual expected results.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was able to get to the solution I was looking for after I reconstructed the database, so I am all set.
Thank you.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 03-09-2023 02:18 AM | ||
01-24-2025 05:39 AM | |||
08-29-2024 06:18 AM | |||
04-08-2024 06:39 AM | |||
12-10-2024 12:45 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |