Calculate and filter rows by greater than

[darko861]

Hi Community,

I have been going through a file from a Youtuber, please see the link below:

https://www.youtube.com/watch?v=uZ15A13AsHY&list=PLDz00l_jz6zym_YP8ZW11o52niGfCP8pN&index=8

Page 2 of this file has multiple measures, I have created a new measure called Cal w measure:

CAL w measure = CALCULATE(SUM(Order_Details[Tot sales]),Order_Details[Tot sales]>10000)

I want to display each ProductName that has values over 10 000 (e.g. the product Camembert Pierrot has the value 17 295 in column CAL Tot Sales, which I want to be displayed in the column CAL w measure too) unfortunately, it sums all the values into 41 369.50 for the Year 1998 and 10 540.00 for the Year 1997. How can I tweak the code using the Calculate function?

I have also tried using this measure:

CAL w measure = CALCULATE(SUM(Order_Details[Tot sales]),FILTER(Order_Details,Order_Details[Tot sales]>10000))

But I get the same result.

 

[Greg_Deckler · Accepted solution]

@darko861 Without having downloaded the file, perhaps you need an ALLEXCEPT and specify ProductName.

[darko861]

CAL w measure = CALCULATE(SUM(Order_Details[Tot sales]),FILTER(ALLEXCEPT(FilteredProductsTable,FilteredProductsTable[ProductName]),[SUM of Total sales]>10000))

Yes, this seems to work!

[darko861]

https://www.dropbox.com/s/00e8hd137xgi7i9/8%20DAX%20Fridays%21%20CALCULATE_2_Curbal.pbix?dl=0

@Greg_Deckler ,try this link