A measure to filter a value through more than one column

[Anonymous]

For one of my visuals I want to use the same column of data twice for my value field, but to output the data I want to show it requires two different set of filtering in the visual level filter field. The 2nd set of filtering being more complicated since I require more columns to output the data I want.

Is there a way to create a measure that filters thru multiple columns?

This quick measure only lets you add one filter, I'd like to add on to this measure and include more.

CALCULATE( COUNTA('Picked'[Reg Pick No.]), 'Picked'[Source Document] IN { "Assembly Consumption" } )

Example of the 2nd set of filtering

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

After the caclulate you can apply multiple filters:

Measure =
CALCULATE (
    COUNTA ( 'Picked'[Reg Pick No.] ),
    'Picked'[Source Document] IN { "Assembly Consumption" },
    'Picked'[Action Type] = "Take",
    'Picked'[source document] = "Assembly Consumption",
    'Picked'[WH Document Type] <> "shipment"
)

Is that what you were looking for?