Forum Discussion
Top N
Hello, I do have another question regarding the filter on visual level for top n filter. Unfortunately MS Power BI filters the Data correctly, but in case I want to show percentage figures in rel...
Hi Chihiro,
For one thing, You can create measure rather use the report visual filter level. For example, you want to display per year's top 5 products and sales.
You can create a new table by clicking "New Table" under modeling on home page.
New table=TOPN(5, SUMMARIZE(Table, [Year], [Product name],“TotalSales”, SUMX(Table[sales])),Table[sales])
For another method, you can create a calcualted column using the following formula. Then add the new column as visual filter, you can select top n, you will get expected result.
totalsales=CALCULATE(SUM(Table[sales]),ALLEXCEPT(Table,Table[Year],Table[Product name]))
If this is not what you want, please share more details or sample table for further analysis.
Thanks,
Angelia
Didn't think of creating another table rather than visual. That'd make thing much simpler for OP I believe.