Forum Discussion

Asa94's avatar
Asa94
Helper I
5 years ago
Solved

Matrix Visualization of a Calculated Column versus a Measure

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

 

 

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])))

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      Asa94
      Helper I
      5 years ago

      amitchandak , thank you so much! 🙂

       

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