Forum Discussion

AnaAlbano's avatar
AnaAlbano
Icon for Helper I rankHelper I
3 years ago
Solved

Results based on filtered values

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 😀



4 Replies

  • 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

      • amitchandak's avatar
        amitchandak
        Icon for Super User rankSuper User

        AnaAlbano , there is no comma before < 5

         

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