Average in matrix

[Sisko]

Hi, 

how can I get the average of week in matrix? Now its show for every day own number. 

Value average per Week Number =

AVERAGEX(

    KEEPFILTERS(VALUES('Table1'[Week Number])),

    CALCULATE(SUM('Table2'[Value]))

)

[v-yulgu-msft · Accepted solution]

Hi @Sisko ,

By now, it is not available to hide those average columns before total. 

As a workaround, we could just hide values while keep column headers remain, with below measure.

Value average per Week Number = IF(ISINSCOPE(Table1[NameofDay]),BLANK(),
AVERAGEX(
KEEPFILTERS(VALUES('Table1'[Week Number])),
CALCULATE(SUM('Table1'[Value]))
))

Best regards,

Yuliana Gu

[Sisko]

Hi,

okay, I get the average but how I get hide those average before total? 

---

@Sisko wrote:

Hi, 

how can I get the average of week in matrix? Now its show for every day own number. 

Value average per Week Number =

AVERAGEX(

    KEEPFILTERS(VALUES('Table1'[Week Number])),

    CALCULATE(SUM('Table2'[Value]))

)

---

---