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 IHi - still working on this - have been ill for a couple of days - not quite got it - but studying suggested answer.
Stan
v-dineshya
Community Support
Community SupportHi stan_w_gifford ,
As you mentioned in your previous response, You are working on proposed solution suggested by jaineshp . Please do let us know if you have any further queries.
Regards,
Dinesh
- jaineshp
Memorable Member
Hey v-dineshya,
Thank you for the kind recognition - always happy to contribute to our community's success!
Best Regards,
Jainesh Poojara | Power BI Developer
