Add a filter to a card that uses a measure

[smmoore34]

I have created a measure that counts the number of values in a table and applied it to a card. I want to have another card with the same measure but with a filter. When I look at the filter on this visual I'm not able to add a data fileld to filter on card visual.

Is there a way I can add a filter to the measure?

Here is my measure: 

# Civil Assigned = COUNT(CIVIL_SC1_Assigned[callid])

I have filters on a table visual: 

I want to have a card that uses the measure shown above with these filters.

I appreciate any help!

[smmoore34]

Thank-you!

[v-xinruzhu-msft]

Hi @smmoore34 

You can create a new measure, then put the new measure to the card visual.

e.g 

Measure =
CALCULATE (
    [# Civil Assigned],
    FILTER (
        CIVIL_SC1_Assigned,
        NOT ( CIVIL_SC1_Assigned[CIVIL_remian.unit] IN { "SC1", "SC2", BLANK () } )
            && CIVIL_SC1_Assigned[number] <> BLANK ()
    )
)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin · Accepted solution]

Create another measure .