Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to write a set analysis expression that excludes values from a measure below a threshold amount. We're looking at bottom 20 customers over a specific time period and we want to exclude customers to whom we've sold less than 1,040,000 pounds of product. Here's the expression I have so far, I think I'm close but I can't quite get it to work:
num(sum({$<sum([Pounds Sold])={">$(1040000)"}>}[Pounds Sold]),'#,##0;-#,##0')
The number function at the beginning is not absolutely necessary, I can always format it within the table. Any help would be much appreciated.
sum({$<[Pounds Sold]={">1040000"}>}[Pounds Sold])
If I misunderstood and you need to sum up the value for the customer before testing, then
sum({$<[Customer]={"=Sum([Pounds Sold]) > 1040000"}>}[Pounds Sold])
You can add the Num function if you like.
-Rob
Is there only one [Pounds Sold] value per Customer?
-Rob
Hi Rob, yes there is just one [Pounds Sold] value per customer in this instance, it doesn't need to be any more granular than at the customer level
sum({$<[Pounds Sold]={">1040000"}>}[Pounds Sold])
If I misunderstood and you need to sum up the value for the customer before testing, then
sum({$<[Customer]={"=Sum([Pounds Sold]) > 1040000"}>}[Pounds Sold])
You can add the Num function if you like.
-Rob
Hi Rob, the second expression worked! Thank you!
-Chris