CODEWITHSUNDEEP
powerbidax
Fabio Manniti
Fabio Manniti

Reputation: 171

Power BI: Filter based on SUM

I have a horizontal bar visual where I’ve plotted the users with the highest sales.

It is "user name" vs "SUM(sales)" (user names and sales are in two different tables).

I’ve also used a filter as I only want to see users with SUM(sales)>1000€.

Now, on this page I want to put other visuals so that I can see information about this group of users, such as:

However, if I use a page level filter on sales, I can only filter a single sale value and not the sum for the user.

How can I filter the page based on a user’s total sales?

Upvotes: 2

Views: 2672

Answers (1)

Matt Kocak
Matt Kocak

Reputation: 808

You could create a calculated column for a user’s total sales in your username table and then filter based on that.

Total Sales = CALCULATE(SUM(Table2[sales]))

There’re also solutions utilizing GROUP BY if you prefer that.

Upvotes: 2

Related Questions