Forum Discussion
Solved
dividing by unique values. Do not use sum or count
I have these 2 tables YTD and Budgets. I need to create a measure in YTD, where it sum the Booked session as per centre , divide that by number of days and whatever the result is, Divide that by staf...
Hi Ryan, First of all , thanks so much for your response. Even after everything, i was not able to get the formulas to work for every centre.
Finally , i found the solution, by just changing the cross filter direction (as below) to 'Both' in relations.
Thanks again for your help
Hi Ryan, First of all , thanks so much for your response. Even after everything, i was not able to get the formulas to work for every centre.
Finally , i found the solution, by just changing the cross filter direction (as below) to 'Both' in relations.
Thanks again for your help
ryan_mayu
Super User
Super Useryou are welcome