Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure filtered by dates

Hello - My measure below returns results as expected until the underlined part. I need to add more filtering with dates that I can't seem to do. I want to be able to say X date (related table) is les...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the response and sorry for my delayed response. Still getting an error...

 

Measure 2 = CALCULATE(COUNT(Opportunity[OpportunityId]),USERELATIONSHIP(Opportunity[ParentContactId],altus_leadstage[altus_Contact]),altus_leadstage[altus_name]="MQL" && altus_leadstage[altus_Date]<MAX(Opportunity[CreatedOn]))
 

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Try this measure

Measure 2 = CALCULATE(COUNT(Opportunity[OpportunityId]),USERELATIONSHIP(Opportunity[ParentContactId],altus_leadstage[altus_Contact]),FILTER(altus_leadstage,altus_leadstage[altus_name]="MQL"&&altus_leadstage[altus_Date]<MAX(Opportunity[CreatedOn])))

If it does not help, then share the link from where i can download your PBI file.  Clearly show the problematic measure there.