Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
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
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
Wow - Thank you for the response. This works!
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |