Sum the value by filter is a "list"

[Rachel_tsao]

Hi all,

Could you light me up how to create a measure which summary the value in [data] by only filter the type in the [list], for example in below 2 table [Data] & [List], I like to have a mearue= sum (A,E,Z)=10+15+30=55. I ask this question because the [list] will be different by time, so I wish to have a dynamic filter for my summary value. Appreciated for your help!

1. Data

TYPE	Value
A	10
B	15
C	5
D	20
E	15
…	…
Y	20
Z	30

2. List

TYPE

A

E

Z

[amitchandak]

@Rachel_tsao ,

You can try in. I think it works as a table column

measure = calculate(sum(Data[Value]), filter(Data, Date[Type] in values(List[Type])))

measure = calculate(sum(Data[Value]), filter(Data, Date[Type] in List))

measure = calculate(sum(Data[Value]), filter(Data, Date[Type] in {"A","E","Z"}))

[Greg_Deckler · Accepted solution]

@Rachel_tsao - Test:

Measure 39 = SUMX(FILTER('Table (39)',[TYPE] IN SELECTCOLUMNS('Table (39a)',"Type",[TYPE])),[Value])

Deputy PBIX, page 39.