Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
mumair
Helper I
Helper I

How to filter a measure by all values

So currently I have DAX code as follows:

 

Measure = sumx(FILTER(Qty, Qty[ID #] = "53101"), [Sales])

 

This correctly sums up all the sales for a given ID. However, I want to do this for all sales across all IDs. How do I do this? Also, sales is a measure and not a column if that makes a difference.

12 REPLIES 12

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.