Forum Discussion
stan_w_gifford
Helper I
Helper IAdvice/howto - many to 1 relationship
Good morning/afternoon. I cannot get my head around this so I cast this to the community. I have two tables Table1 Name CM Appointments Joe Joe2025-01 1 Joe ...
As mentioned the actual measure is;
Leave Days Measure =VAR CurrentName = AllSelected(Consolidated2[LeaveKey])RETURNCALCULATE(SUM(Leave[Days_Leave]),Leave[LeaveKey] in CurrentName,ALL(Consolidated2))To Get the correct value in the card I made 4 descrete measure (I have 4 salespeople) like.....AL_Leanne = sumx(Filter(Consolidated2,Consolidated2[Who]="Leanne"),[Leave Days])/Calculate(COUNTROWS(Consolidated2),Consolidated2[Who]="Leanne")So simplistically, the measure finds the number of days leave between two days via the leave key and uses ALL the descrete LEAVEKEY values exposed via the filter.Then the measure for each salesperson calculates the leave from the measure sumerised - then divided by the number of entries in Consolidated2 - AKA Table1.I am going to be marking this response as the correct/Solution - however really some previous answers led me to develop this - so really there are multiple correct solutions...................Stan
stan_w_giffordHelper I
Helper IWhoops - forgot the measure I am using;
Leave Days Measure =
VAR CurrentName = MAX(Consolidated2[LeaveKey]) var DL=0
RETURN
CALCULATE(
SUM(Leave[Days_Leave]),
Leave[LeaveKey] = CurrentName,
ALL(Consolidated2)
)
Consolidated2 is equivelant to table 1 and Leave is equivalent to Table2
I suspect the MAX is freaking the calculation out.....