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

Return data only if there are more than 6 records with filter

Hi,

 

I have a survey application, I need to create a report in PBI for the result with some filters (age, gender, title, civil status, etc.), but how to create a report that does not display data when the filter result is lower 6 records to not be able to identify who answered?

 

How to limit display of data to display only if it returns more than 6 records?

 

In SSRS I use the query:

 

Select *
From tb_questionario
Where
id_cargonivel in (@parameter1)
And id_tempoempresa in (@parameter2)
And id_idade in (@parameter3)
And id_sexo in (@parameter4)
And id_estadocivil in (@parameter5)
And id_grupofamiliar in (@parameter6)
And (Select count(id_cargonivel) From tb_questionario
Where 
id_cargonivel in (@parameter1)
And id_tempoempresa in (@parameter2)
And id_idade in (@parameter3)
And id_sexo in (@parameter4)
And id_estadocivil in (@parameter5)
And id_grupofamiliar in (@parameter6)) >= 6;

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Return data only if there are more than 6 records with filter

HI, @Marjukavic

      you may try to use ALLSELECTED Function to create a measure:

 

Measure = CALCULATE(COUNT(Table1[id_cargonivel]),ALLSELECTED(Table1[parameter1]),ALLSELECTED(Table1[parameter2]),ALLSELECTED(Table1[parameter3]),ALLSELECTED(Table1[parameter4]),ALLSELECTED(Table1[parameter5]),ALLSELECTED(Table1[parameter6]))

 and then drag it into the visual level filter and set filter >=6

 

8.PNG

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Return data only if there are more than 6 records with filter

HI, @Marjukavic

      you may try to use ALLSELECTED Function to create a measure:

 

Measure = CALCULATE(COUNT(Table1[id_cargonivel]),ALLSELECTED(Table1[parameter1]),ALLSELECTED(Table1[parameter2]),ALLSELECTED(Table1[parameter3]),ALLSELECTED(Table1[parameter4]),ALLSELECTED(Table1[parameter5]),ALLSELECTED(Table1[parameter6]))

 and then drag it into the visual level filter and set filter >=6

 

8.PNG

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Marjukavic Frequent Visitor
Frequent Visitor

Re: Return data only if there are more than 6 records with filter

Hi Lin,

 

Thank you so much, it worked.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 390 members 4,444 guests
Please welcome our newest community members: