AnonymousNot applicable6 years agoSolvedFilterI have a measure for calculating net sale, based on 3 categories. How I can filter these categories?Please helpAnonymous to Anonymous6 years agoSolved CALCULATE ([Net Sale],FILTER (Sale,Sale[Category] = "A"|| Sale[Category] = "B"|| Sale[Category] = "C"))
Anonymous to Anonymous6 years agoSolved CALCULATE ([Net Sale],FILTER (Sale,Sale[Category] = "A"|| Sale[Category] = "B"|| Sale[Category] = "C"))
Anonymous to Anonymous6 years agoSolved CALCULATE ([Net Sale],FILTER (Sale,Sale[Category] = "A"|| Sale[Category] = "B"|| Sale[Category] = "C"))
3 RepliesReplies sorted by Most LikedAnonymousNot applicable6 years agoAnonymous In case you are looking for net sales of a specific category use thiscalculate(sum(table[sales]),category="A") If are looking for net sales per categorycalculate(sum(table[sales]),allexcept(table,table[category])) Please share dummy data in case it does not workAnonymousNot applicable to Anonymous6 years agoIn my scenario, I have 5 categoeries avialable, but I need net sale of 3 categories only.Suppose categories namely, A,B,C,D,E.SUM(Sales) WHERE Category = A,B,CAnonymousNot applicable to Anonymous6 years agoSolved CALCULATE ([Net Sale],FILTER (Sale,Sale[Category] = "A"|| Sale[Category] = "B"|| Sale[Category] = "C"))
AnonymousNot applicable6 years agoAnonymous In case you are looking for net sales of a specific category use thiscalculate(sum(table[sales]),category="A") If are looking for net sales per categorycalculate(sum(table[sales]),allexcept(table,table[category])) Please share dummy data in case it does not work
AnonymousNot applicable to Anonymous6 years agoIn my scenario, I have 5 categoeries avialable, but I need net sale of 3 categories only.Suppose categories namely, A,B,C,D,E.SUM(Sales) WHERE Category = A,B,C
AnonymousNot applicable to Anonymous6 years agoSolved CALCULATE ([Net Sale],FILTER (Sale,Sale[Category] = "A"|| Sale[Category] = "B"|| Sale[Category] = "C"))
