Forum Discussion
AdministratorUSERELATIONSHIP in a DAX formula with two measures
Good morning
I have a problem:
I have a DAX measure: Opp New Cualif = [SUM Ing Opp New Cualif] / [COUNT Opp New Cualif]
But I need to put a USERELATIONSHIP. I mean:
Opp Nuevas Cualif = [SUM Ing Opp Nuevas Cualif] / [COUNT Opp Nuevas cualif],
USE RELATIONSHIP (Calendar[date], Opportunity[estimatedclosedate])
But it gives me error and doesn't let me do it.
How can I make a measurement that divides two measures and also lets me use the USERELATIONSHIP?
Thank you very much in advance and greetings!
2 Replies
- amitchandak
Super User
Syndicate_Admin , there should be a join or inactive join between these two tables to use USERELATIONSHIP
USERELATIONSHIP (Calendar[date], Opportunity[estimatedclosedate])
What is error you are getting
refer if this can help
Syndicate_Admin@Syndicate_Admin the mistake it gives me is this one from here:
Thanks a lot!
Currently I do NOT have any active relationship, as it does not suit me, for this reason I use USERELATIONSHIP.
