Forum Discussion

Oros's avatar
Oros
Post Prodigy
1 year ago
Solved

Filtered measure

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.

 

Need Help
  • Irwan's avatar
    Irwan
    1 year ago

    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.

2 Replies

  • Irwan's avatar
    Irwan
    Super User
    1 year ago

    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.