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

[Marjukavic]

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;

[v-lili6-msft · Accepted solution]

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

Best Regards,

Lin

[Marjukavic]

Hi Lin,

Thank you so much, it worked.