Forum Discussion
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...
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.
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.
