Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to build a measure (sales) for specific value (item group), without to select it.
I tried to use if, and its showing the correct result only if I select the specific value in the sheet (sunglasses):
=IF([item group]='sunglasses',[total sales - amount])
I want it to work and show to total sales of sunglasses without making the selection in the whole sheet.
Sum({< [item group] = {"sunglasses"} >} Sales) ought to do the trick.
Sum({< [item group] = {"sunglasses"} >} Sales) ought to do the trick.
it's not working, I always get 0.
"sales" should me a measure or a variable? anyways, I get 0 with both.
Sales should be the field you are trying to sum. The set analysis should exactly match both the field name you are filtering on and the value you are filtering for, including capitalization / spacing / etc.
It works! thank you for the explanation! 😀