I´m strugelling trying to resolve a query. What I need to do is to calculate a measure that combine a measure (the counts of leads) filter by the offers that has status as "Active" and the field "approbeoffer" is TRUE(). Additionally I need to USERELATIONSHIP between the date of creation of the offer and my calendar table.
My Measures are:
Leads Approbed and status offer = CALCULATE([Total de Leads], FILTER(sing_leadadquisicions, sing_leadadquisicions[sing_aprobadoofer] = TRUE()), FILTER(RELATEDTABLE(sing_ofertaadquisicions), sing_ofertaadquisicions[statecode] = "Activo"))
AND THEN
Oferta Aprobada por fecha de creac oferta = CALCULATE([Leads Aprobados y estado oferta activo], USERELATIONSHIP('Calendar'[DateKey], sing_ofertaadquisicions[DateKey_fec_creacion_oferta]))
My offer table is related with the Calendar table by their DateKey field and my leads table is related by different DateKey field with the Calendar table that has their own DateKey field. The only one relationship that is active between leads and Calendar is the date of creation of the lead and my Calendar DateKey.
The thing is that my measure returns a value that is below the value that should return.
In addition to this I checked that all my date columns are in the same format not only in PowerBI but also in PowerQuery.
I really appreciate your help! I don´t know what is happening
Thanks
Regards!
