Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Cannot use "does not equal" in Filter function?

I have a calculated column that I use to calculate the weighted average for my dataset. Oringially, in my query, I filtered out data in a column that had the amount of 0. I used the following column ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for the reply.

 

What I am trying to do is by row, multiply the Days Old column by the Total Amount Due column. Then divide this result by the sum of the entire Days Old column. 

 

There is a column ID Number that should be unique per row, so this filter I guess is included to make sure it multiples only by each row (not sure if that is necessary).

 

And then finally I also now want to filter this calculation to not include any rows where the Total Amount Due column is zero. So if the Total Amount Due column is zero for a particular row, it should not multiply Days Old by Total Amount due and it should also not include this row in the sum of Days Old column which is what I am dividing by at the end.

 

Let me know if that doesn't make sense.

 

 

v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

If convenient, share us an example. Check if the following calculated column works.

Column =
DIVIDE (
    Data[Days Old] * Data[Total Amount Due],
    SUMX ( Data, Data[Days Old] * Data[Total Amount Due] )
)