cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
michelle077 Frequent Visitor
Frequent Visitor

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
michelle077 Frequent Visitor
Frequent Visitor

Re: Help with Filtering Dimensions

I was able to get to the solution I was looking for after I reconstructed the database, so I am all set.

Thank you.

View solution in original post

5 REPLIES 5
VasTg Established Member
Established Member

Re: Help with Filtering Dimensions

@michelle077 

 

Please see the DAX for this and replace with response column. 

 

Measure = IF(COUNT(financials[Segment])<5,0,COUNT(financials[Segment]))

Capture 1.PNGCapture2.PNG

 

 

 

 

 

 

 

 

 

I have used limit 10 in the images.

 

 

If this helps, Please mark this as a solution.

Kudos are good too.

 

michelle077 Frequent Visitor
Frequent Visitor

Re: Help with Filtering Dimensions

@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!

VasTg Established Member
Established Member

Re: Help with Filtering Dimensions

@michelle077 

 

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.

michelle077 Frequent Visitor
Frequent Visitor

Re: Help with Filtering Dimensions

@VasTg ,

 

I am looking for a total count by category group.

michelle077 Frequent Visitor
Frequent Visitor

Re: Help with Filtering Dimensions

I was able to get to the solution I was looking for after I reconstructed the database, so I am all set.

Thank you.

View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)