calculated weighted average after applying filter on 4 different columns based on a value

Sania-F — Tue, 28 Feb 2023 08:14:30 GMT

Hi Everyone,

calculated weighted average after applying filter on 4 different columns based on a value.

sample columns A, B,C,D,E,F. I have to do something as below :

I need to calculate product = A* B
Then I need to Sum(product) /sum (B)

and filter this based on some conditions

select sum(product)/sum(B) from

(

select DISTINCT A

,A*B as product

from

Table

where C in ('value1','value 2')

and Month in ('APR-21')

and D in ('1')

and F in ('v1','v2','v3')

and E in ('value 1','value2')

) weighted-average

#calculate #filter #sum #average #weightedAverage #powerBI #DAX

topic calculated weighted average after applying filter on 4 different columns based on a value in DAX Commands and Tips