Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter

I have a measure for calculating net sale, based on 3 categories. How I can filter these categories? Please help
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Solved

     

    CALCULATE (
    [Net Sale],
    FILTER (
    Sale,
    Sale[Category] = "A"
    ||
    Sale[Category] = "B"
    ||
    Sale[Category] = "C"
    )
    )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 
In case you are looking for net sales of a specific category use this
calculate(sum(table[sales]),category="A")
 If are looking for net sales per category

calculate(sum(table[sales]),allexcept(table,table[category]))

 

Please share dummy data in case it does not work

Anonymous's avatar
Anonymous
Not applicable
6 years ago

In 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