Calculated columns - calculation of averages

[ORLI]

How to calculate the average x row for this table, using calculated column?

A	B	C
32		15
24	16	8

[ORLI]

Almost that, but note that in the calculation values 0 (zero) or empty cells must be disregarded

[SpartaBI · Accepted solution]

@ORLI 

Column = 
VAR _numerator = 'Table'[A] + 'Table'[B] + 'Table'[C]
VAR _denominator = INT('Table'[A] <> 0) + INT('Table'[B] <> 0) + INT('Table'[C] <> 0)
RETURN
    DIVIDE(_numerator, _denominator)

Please don't forget to accept the message as a solution for community visibility.
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. Please give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

[ORLI]

SPARTABI THANK YOU SO MUCH!! YOU ARE AWESOME!!!

[SpartaBI]

@ORLI my pleasure 🙂 check out the report, trust me 🙂

[SpartaBI]

@ORLI do you mean like this or something else?

      

Showcase Report – Contoso By SpartaBI