Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter Star Rating

Hello,

I have a table with several columns. I use a quickmeasure that displays a star rating in several columns. How can I add a filter that allows me to filter by the number of stars?

Thank you!

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , hope star rating is measure, then you use numeric parameter or dynamic segmentation

     

    sumx(filter(Values(Table[Name]), [Star Rating] > [what if measure]) , [Name])

     

    Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I'm using this code for each column to show my values as a star rating: 

      "Measure NAME" = var Avgstar = AVERAGE("SOURCE"["COLUMN"]) VAR star = (5 - Avgstar) Return REPT(UNICHAR(11088),Avgstar)&REPT(UNICHAR(9734),star)

       

      So how do I combine that with sumx?