Results based on filtered values

[AnaAlbano]

Hello community!

I´m trying to performe a task in Power BI and I´m not finding the right way to do it 😞

The case is: I have a dashboard for a survey analisis. And for the free text answers, we wanted to add a condition that if the user filtered the data (country, function, etc) and the end result is less than 5 responses, the chart with the open text answer should not display any data.

Do you have any idea how could I make this work?

Thank you very much 😀

[amitchandak]

@AnaAlbano , Create a measure like this and use that in visual level filter

if( Calculate(countrows(Table), allselected() ) <5,1, 0)

check this measure =0 in visual level filter

[AnaAlbano]

Thank you @amitchandak !

I created the measure, but I am getting this error:

Any idea? 🙂

[amitchandak · Accepted solution]

@AnaAlbano , there is no comma before < 5

if( Calculate(countrows(Table), allselected() ) <5,1, 0)

[AnaAlbano]

Thank you very much @amitchandak! It worked!