Forum Discussion
Average conditioned
Hello everyone, I come back here because i got great answers last time i ask my questions here. I would like to solve the problematic following : I have two data tables in PBI. They are l...
Did something go haywire in the posting? Is the ID in Table 2 supposed to match the ID in Table 1? Key1, Key2...?
Assuming the answer is yes, perhaps:
AverageProgress = VAR __tmpTable = FILTER('Progress',[Take into account]=1) RETURN AVERAGEX(__tmpTable,[progress])Put into a table along with Hospital and Phase. Make sure Hospital and Phase are related based on [ID] columns.