Filter

[Anonymous]

I have a measure for calculating net sale, based on 3 categories. How I can filter these categories?

Please help

[Anonymous]

@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 · Accepted solution]

Solved

CALCULATE (

[Net Sale],

FILTER (

Sale,

Sale[Category] = "A"

||

Sale[Category] = "B"

||

Sale[Category] = "C"

)

)

[Anonymous]

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