Forum Discussion
Impactful IndividualIgnore blank values in averagex measure
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
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)))
1 Reply
- amitchandak
Super User
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)))