Forum Discussion
Userelationship not using inactive date relation
I have the following relationships in my data model: There is an active relationship between DimCalendar[Datum] and FactAppointment[Datum afspraak]. There is an inactive relationship bet...
Anonymous You can't use a VAR with CALCULATE that way. You would have to have numberOfNewPatients as a separate measure and then your finalMeasure as a separate measure. CALCULATE is not going to recalculate a VAR because VAR's are static (I know that doesn't make sense but it is no less a fact).
Anonymous You can't use a VAR with CALCULATE that way. You would have to have numberOfNewPatients as a separate measure and then your finalMeasure as a separate measure. CALCULATE is not going to recalculate a VAR because VAR's are static (I know that doesn't make sense but it is no less a fact).
Thank you Greg_Deckler! This worked for me.