Forum Discussion

hanygameel's avatar
hanygameel
Helper I
3 years ago
Solved

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's avatar
    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's avatar
    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. 
tamerj1's avatar
tamerj1
Community Champion
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. 
hanygameel's avatar
hanygameel
Helper I
3 years ago

Thank you Very Much
i got it