Filtered measure

[Oros]

Hello,

I have a simple table and I would like to have a measure that show total sales of certain products and sold to certain customers.

For example, I would like to see in MEASURE, the total sales of Apple and Banana sold only to ABC and XYZ.

[Irwan · Accepted solution]

hello @Oros 

you can do this in some ways.

1. use SUM in measure and use slicer to choose selection

Total Sales = SUM('Table'[Sales])

2. use FILTER in measure

Total Sales 2 =
CALCULATE(
    SUM('Table'[Sales]),
    FILTER(
        'Table',
        (
            'Table'[Product]="Apple"||'Table'[Product]="Banana"
        )&&
        (
            'Table'[Customer]="ABC"||'Table'[Customer]="XYZ"
        )
    )
)

Hope this will help.

Thank you.

[Oros]

Hi@Irwan,

 It works!  Thanks.