Forum Discussion
setis
Post Partisan
Post PartisanUSERELATIONSHIP with several conditions
Dear experts, I am struggling with a measure in which I'm trying to combine USERELATIONSHIP and several filters. My measure is thefollowing: Membership Fee=
CALCULATE (
[TotalAmountGLEntry]...
Mariusz and amitchandak
It worked for me doing:
Membership Fee = VAR Acc3011 = CALCULATE ( [TotalAmountGLEntry]; USERELATIONSHIP ( '$G_L Entry'[Posting Date]; 'Date'[Date] ); USERELATIONSHIP('$G_L Entry'[CUSTOMER];'All Customers'[No_]); KEEPFILTERS ('$G_L Entry'[G_L Account No_] = "3011"); KEEPFILTERS ('$G_L Entry'[Document Type] = 2); KEEPFILTERS('$G_L Entry'[CUSTOMER] <> BLANK()) ) VAR Acc3016 = CALCULATE ( [TotalAmountGLEntry]; USERELATIONSHIP ( '$G_L Entry'[Posting Date]; 'Date'[Date] ); USERELATIONSHIP('$G_L Entry'[CUSTOMER];'All Customers'[No_]); KEEPFILTERS ('$G_L Entry'[G_L Account No_] = "3016"); KEEPFILTERS ('$G_L Entry'[Document Type] = 2); KEEPFILTERS('$G_L Entry'[CUSTOMER] <> BLANK()) ) RETURN Acc3011+Acc3016
setisPost Partisan
Post PartisanMariusz Thanks again!
Unfortunately it didn't work either with or without KEEPFILTERS. I'm getting lines for all different G_L Account No_
setisPost Partisan
Post PartisanMariusz and amitchandak
It worked for me doing:
Membership Fee =
VAR Acc3011 =
CALCULATE (
[TotalAmountGLEntry];
USERELATIONSHIP ( '$G_L Entry'[Posting Date]; 'Date'[Date] );
USERELATIONSHIP('$G_L Entry'[CUSTOMER];'All Customers'[No_]);
KEEPFILTERS ('$G_L Entry'[G_L Account No_] = "3011");
KEEPFILTERS ('$G_L Entry'[Document Type] = 2);
KEEPFILTERS('$G_L Entry'[CUSTOMER] <> BLANK())
)
VAR Acc3016 =
CALCULATE (
[TotalAmountGLEntry];
USERELATIONSHIP ( '$G_L Entry'[Posting Date]; 'Date'[Date] );
USERELATIONSHIP('$G_L Entry'[CUSTOMER];'All Customers'[No_]);
KEEPFILTERS ('$G_L Entry'[G_L Account No_] = "3016");
KEEPFILTERS ('$G_L Entry'[Document Type] = 2);
KEEPFILTERS('$G_L Entry'[CUSTOMER] <> BLANK())
)
RETURN
Acc3011+Acc3016