Ignore blank values in averagex measure

[Applicable88]

Hello,

I have a simple AverageX Measure 

Measure = Averagex ( Table1, Table1[Value] / related Table2(Positions))I don't have values for all dates, so in this cells it will display infinite, and if I put that measure into a table it wil show "infinite" as well. Its like having a complete sales table1 but not a related "position" value for all sales.

Only if I use the filter panel and filter out all dates without value I get a Average Value. Since these days contain other important information in other columns I cannot filter them out in the visual. So is it possible to calculate the average and ignoring the blank fields?

Thank you very much in advance.

Best

[amitchandak · Accepted solution]

@Applicable88 , You try like

Averagex ( Table1, divide(Table1[Value] , related (Table2(Positions)) )

or

divide(sum(Table1[Value] ), sumx(Table1, related (Table2(Positions))))

or

divide(sum(Table1[Value] ), sum(Table2(Positions)))