Forum Discussion
nanacobsbs
Helper I
Helper IAverage Dax
The matrix is shown in Fig and Dax Dommand is bellow. Average = AVERAGE('Test'[Nov]) I would like to display the averaged results on each row, what DAX should I use? I want the total ro...
v-aatheeque
Community Support
Community SupportHi nanacobsbs,
can you try this :
Average Display =
IF (
ISINSCOPE('Test'[Date]),
CALCULATE(AVERAGE('Test'[Nov])),
CALCULATE(MAXX(VALUES('Test'[Date]), CALCULATE('Test'[Nov])))
)
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
nanacobsbsHelper I
Helper IThank you for your comment.
I tried above DAX command, but it doesn't work like below.
If the total had shown 26.77 it would have been good.