Average by more values

i have table that have Patient ID invoice no. Doctor Service No. Amount Episode No. ( visit No) 001 22-01 10 654 50 0...

FreemanZ
3 years ago
Hi  hanygameel
try to create a measure with this:
AvgByPatientByEpisode =
AVERAGEX(
SUMMARIZE(
       TableName,
       TableName[Patient ID],
       TableName[Episode No.]
),
SUM(TableName[Amount])
)

In case of failure, please provide more data to cover the complexity of your case.
tamerj1
3 years ago
hanygameel

You can add a column inside SUMMARIZE which is the SUM of the ammount aggregated at the Episode level (which is most probably one value) the FILTER will consider only the values that are above 0 the the averaging is performed.

Forum Discussion