Help> caculate value of items exsited in other filtered column

[Anonymous]

Hello Everyone 

I am new at POWER BI , and stuck in this issue for a while , I hope anyone could help me out 

here it is my stucking part in a simple way among many other relationships and cauclations  

I have a "volume" table , 

item	volume	source
A	1	WEST
A	2	EAST
B	3	WEST
B	4	EAST
C	5	WEST
C	6	EAST

and a "filter" table

filter list

A

B

C

I want to sum the {volume} on the items exsited in filtered column {filter list}

I am using CALCULATE(SUM(volume[volume]),FILTER(volume,SEARCH(volume[Item]),VALUES(filter[filter list]),,0)>0))

this works ok when I only filtered one value , it goes error if I filtered "A" and "B" at the same time .

what is the correct formula should be used ?

I need to create a measure to caculate this ,  build relation between table will not help in my case

thanks

Eric

[Zubair_Muhammad · Accepted solution]

HI @Anonymous

How about this MEASURE

Measure =
CALCULATE (
    SUM ( Volume[volume] ),
    TREATAS ( VALUES ( 'Filter'[filter list] ), Volume[item] )
)

[Zubair_Muhammad · Accepted solution]

HI @Anonymous

How about this MEASURE

Measure =
CALCULATE (
    SUM ( Volume[volume] ),
    TREATAS ( VALUES ( 'Filter'[filter list] ), Volume[item] )
)

[Anonymous]

It works AMARZING!!! 

thanks a lot . I know I could put relationship in this example ,but it real case ,I could not since I need to combine this outcome with other caculations 

but this is definately what I am asking for !

thanks!!!

[Zubair_Muhammad]

@Anonymous

Since both the tables have common field.....they can be joined easily I believe

See file attached

[Zubair_Muhammad · Accepted solution]

@Anonymous

But If there is a relationship between tables,, a simple sum of Volumes should give you the answer as well