Forum Discussion

pvravestein's avatar
pvravestein
Icon for Helper I rankHelper I
5 years ago

Divide multiple columns averages in total average considering also blanks

I calculate averages in my table and also I want a Total average from those averages. But sometime I have no value, then then total average must give the total average from the other averages withou...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

pvravestein , Try like

averagex(filter(Table, Table[Col1]<> 0 && not(isblank(Table[Col1]))),[Table[Col1]])

pvravestein's avatar
pvravestein
Icon for Helper I rankHelper I
5 years ago

Great, thanks.  But forgive me, I am new to DAX and I cannot get it to work.

My table name is change, column names are on top of my screenshot. What will it look like with all data?

Many thanks