Forum Discussion
Show TOP n values with changing the base
Hello, I use Power BI to look at data from surveys. Below is a typical table I usually work with - you can see that the values in respondentID column are not unique, some are repetitive as a piec...
Just to confirm you did try going under Filters, and then change the Filter Type to TopN and then put in your % GT Count of respondantID?
GilbertQ Thank you for replying my question. Yes I tried it. You can see that the % in the last two tables attached are different but the counts of each concept category are same. One has applied the Top n filter and the other does not. I want to use the Top N filter but get same results.
Hi Ying_P
Are you able to share some sample data or images of the differences?
I would suggest instead of using the built in measure creation to create it yourself. And build each measure individuall before you create the final Grand Total measure. In doing so you can see where the measure is different from what you expect to see.
Hi GilbertQ,
Thank you for replying me. I was on vacation last week and did not check emails as frequent as usual. Sorry for the late reply.
I will try to create some measures, at the meantime, if you could help, here is the link to the sample data file I used.
Thanks again!
Ying
I tried to access the file but it gave me a 403 error.