Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Problem Calculating Total Average

Very good to all, I have a problem when calculating a total average based on two averages already calculated with filters since these have negative values and in the filters I eliminate the negative...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Syndicate_Admin , this might be because of row context used

you can avg have using the column in visual

averages(values(Table[column]), [measure] )

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Icon for Administrator rankAdministrator
    4 years ago

    Is there a way for me to be able to use IF with an average so that I only take into account the largest numbers or giuales to 0 of a column?