HELP Calculate Average without Zero values based on measure

[yakovlol]

Hello Team,
Could you please help me with creating a measure?
I need to Calculate the Average for (No group) ignoring zeros. The values for the second column are based on another measure [Count Month]. So I need to ignore zeros but to leave them in the matrix. 

Average CountMonths = 
AVERAGEX(VALUES(Table1[id]),[Count Months])

My matrix with the current calculation

Desired output to have 2 for "No group", but 0 should stay where they are

Many thanks for you help

[Anonymous]

Hi @yakovlol,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng