Daily Average for the Month with Weighted Average

[RogerSteinberg]

Hi,

I am trying to get the daily average of a weighted average value per segment for each month in the year.

My data looks like this:

month	segment	daily avg weighted value
JAN	a	daily average for that month based on the weighted_value col. which should average out the values 4.9, 23.3 , etc.
JAN	b	daily average for that month based on the weighted_value col. which should average out the values 43,61, etc.

I would like to achieve the following:

The daily average for each month per segment for the aggregated weighted values.

How can i achieve this either using a measure or calculated column ?

[v-lili6-msft · Accepted solution]

hi  @RogerSteinberg 

For your case, you could use "ALLXXXX" Function to create a measure like below:

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

Regards,

Lin

[amitchandak]

You can do it using Allexcept or

https://community.powerbi.com/t5/Desktop/highest-value-by-category/td-p/428758

https://community.powerbi.com/t5/Desktop/Calculate-Average-per-category/td-p/362637