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 IOK - I did a sin that I would normally beat my staff for (if I had any staff) - I left some facts out.
1. Not every line in Table 1 would have appointments for a specific CM
2. I want to put the result into a card!
At the moment I have got a measure working - I I put my data into a matrix, it looks like this (all data from Table1)
What I want to put in the card is a single value - from above the value would be 8 (8 days leave over the period)
If I put the measure into the card I get a nice big fat BLANK!