Apply numeric filter (e.g., greater than 1000) on one of the fields in Rows and not based on all

[mpaukee]

I want to create a table/chart of all stores with revenue>1mUSD per Year. In addition I want to include the product names as further drill down option. It is possible in excel to select at what level I want to apply the numeric filter (here the store names), however in Power BI the numeric filter gets applied to the lowest level (which is the product names) and selects only the product with revenuw >1mUSD. Is there a fix available to select the level of aggregation (i.e., at a store level and not products)?

[v-yulgu-msft · Accepted solution]

Hi @mpaukee,

You could create measures to determine which level is based on to aggregate numeric values. You can sum values based on store level or product level. But, for the requirement that conditionally select the level of aggregation is not supported now.

Best regards,

Yuliana Gu

[vanessafvg]

@mpaukee you will need to agregate the data first i would think with a summarize statement into a new table and then  apply the filter