Forum Discussion
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!
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
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?