Forum Discussion
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...
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 , 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])))
amitchandak , thank you so much! 🙂
That measure gave me the same results as the calculated measure. Appreciate it so much