Matrix Visualization of a Calculated Column versus a Measure

[Asa94]

Hi all,

I hope you are well,

I am trying to do a matrix visualization based of values that are in a calculated column. The values in the calculated column are correct. However, when I use the matrix, it sums the values as shown below:

Just some context:

1. I need to show the average number of orders per dealer code, per day, per month:

- Dealer code is shown

- Per day is Monday to Friday (or Weeknum)

- Per month is Month (or Monthnum)

2. I used the following DAX to calculate the average:

Is there a way I can use a Measure rather than the calculated column? Or another way to go around this. Any help will be appreciated 🙂

Kind Regards,

Asa

[amitchandak · Accepted solution]

@Asa94 , Try a measure like

calculate(average(inv[order]), filter(allselected(inv), inv[dealercode] =max( inv[dealercode]) && inv[monthnum] = max(inv[monthnum]) && inv[weeknum] = max(inv[weeknum])))

[Asa94]

@amitchandak , thank you so much! 🙂

That measure gave me the same results as the calculated measure. Appreciate it so much