Measure: Count IF Date

[HenryJS]

Hi all,

How do I create a measure that:

Counts 'Has JobRef on Advert Export?' IF 'Export Adverts.Closing Date' is past today AND 'JobStatus' is ' Open'?

Thanks,

Henry

[amitchandak · Accepted solution]

Try new measure

calculate(count(table[Has JobRef on Advert Export?]),table['Export Adverts.Closing Date']<today() , table[JobStatus]="Open")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

[az38]

Hi @HenryJS 

try

CALCULATE(Count('Table'[Has JobRef on Advert Export?]), ALL('Table'), 'Table'[Export Adverts.Closing Date] > today(), 'Table'[JobStatus]="Open")

do not hesitate to give a kudo to useful posts and mark solutions as solution