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...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    AnaAlbano , there is no comma before < 5

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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's avatar
    AnaAlbano
    Icon for Helper I rankHelper I
    3 years ago

    Thank you amitchandak !

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

     

    Any idea? 🙂

    • amitchandak's avatar
      amitchandak
      Icon for Super User rankSuper User
      3 years ago

      AnaAlbano , there is no comma before < 5

       

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

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

        Thank you very much @amitchandak! It worked!