Count filter use relationship

Hi Anonymous ,

You did not provide sample data, but I did the test based on the data in your previous posts.

Please refer to the dax code for measure:

Measure =

CALCULATE (

COUNT ( 'Campaign Responses'[Campaign Name] ),

FILTER (

'Campaign Responses',

YEARFRAC (MAX(Opportunities[Created On]), 'Campaign Responses'[Date] ) >= 0

&& YEARFRAC ( MAX(Opportunities[Created On]), 'Campaign Responses'[Date] ) <= 1

)

,USERELATIONSHIP('Campaign Responses'[Contact Name],Opportunities[Primary Contact Name])

)

And you should create an inactive relationship between 'Campaign Responses' and 'Opportunities' for USERELATIONSHIP function :

For more details, please refer to pbix file:https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EfE0_V2UdL1ItePx07JxA7sBwuJoXnbjuoZ2Ydk3TlxuxQ?e=IPmJhg

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

Best Regards,

Dedmon Dai