Need help with filters

[AKR719]

Hi,

I have a 'property' table and a 'contract' table, which are having a 1:n relation. My report is showing the property table. There are some slicers on the property table which are working fine (e.g. filtering on the country, type or status of property). I've figured out that a measure

count_of_selected_contracts = Count(contracts)

returs the number of the selected property items. But how to count the number of the selected property items while applying an extra condition, which is not set via slicer? I need something like

count_of_selected_active, contracts = Count(contracts, 'contracts'[Status]="active")

But the above doesn't work. I need something that gives the number of active contracts which are related to the selected property items. Could someone please help me out? Thanks!

[tamerj1 · Accepted solution]

Hi @AKR719 

you can try

count_of_selected_active, contracts =

COUNTROWS (

FILTER ( contracts, contracts[Status] = "active" )

)