Forum Discussion

Paddhof1984's avatar
Paddhof1984
Helper III
9 years ago

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...
Need Help
Tips and Tricks
Paddhof1984's avatar
Paddhof1984
Helper III
9 years ago

Hello Chihiro,

 

I do have following columns: product group name, turnover (year). So in case I am creating a new table chart with product group name as row name and I am using the values shown in the columns. But, like I already said, if I only want to show top n turnovers by products for a specifig year, MS Power BI calculates the percentage per product only from top n products and not total products. Power BI keeps cutting of the products and their turnover, which don't appear in the top n.

Chihiro's avatar
Chihiro
Solution Sage
9 years ago
Paddhof1984 wrote:

Power BI keeps cutting of the products and their turnover, which don't appear in the top n.

Hence, use of FILTER(ALL()) (or ALL()). Basically it ignores all applied filter and will evaluate based on entire table. Exact construct of formula will depend on your data set.

 

https://msdn.microsoft.com/en-us/library/ee634802.aspx