And in Set Analysis

[melissapluke]

Hi all,

I have a table where Region can be listed multiple times. I am looking to count Region only when Region has a status of Scheduled and a Status of Complete. If I do this it counts Region if it has either of those.

Count(distinct {<[Status]={'Scheduled','Complete'} >}[Region])

Essentially I want to do this, but i know the syntax isn't correct. 

Count(distinct {<[Status]={'Scheduled'} and [Status]={'Complete'} >}[Region])

Thanks!

Melissa

[Kushal_Chawda · Accepted solution]

try below

=Count(DISTINCT {<Region=p({<Status={'Scheduled'}>})*p({<Status={'Complete'}>})>}Region)

[melissapluke]

Thank you, that works!