DAX pivot Average

[Vanessa250919]

Hello all,

I created one table Pivot but I have an issue, I try to make an average . But I need Average not AverageX it's possible ? 

pivot =

GROUPBY(

MASTERTABLE,MASTERTABLE[POSTAL_CODE],MASTERTABLE[DIENST], MASTERTABLE[POSTALCODE_DIENST],

"PAK_VOL_REEL",AVERAGEx(CURRENTGROUP(),MASTERTABLE[PAK_VOLUME_REEL]),

"PAK_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[PAK_VOLUME_ORG]),

"EE_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[EE_INDIV_ORG]),

"EE_VOL_REEL",SUMX(CURRENTGROUP(),MASTERTABLE[EE_INDIV_REEL]),

"ENA_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[ENA_VOLUME_ORG]),

"ENA_VOL_REEL",SUMX(CURRENTGROUP(),MASTERTABLE[ENA_VOLUME_REEL]),

"FNGF_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[FNGF_VOLUME_ORG]),

"FNGF_VOL_REEL",SUMX(CURRENTGROUP(),MASTERTABLE[FNGF_VOLUME_REEL]),

"KRANT_VOL_ORG",AVERAGEX(CURRENTGROUP(),MASTERTABLE[KRANT_VOLUME_ORG]),

"KRANT_VOL_REEL",SUMX(CURRENTGROUP(),MASTERTABLE[KRANT_VOLUME_REEL])

[Fowmy]

@Vanessa250919 

I modified it but not sure if it works for you, please try:

pivot =
ADDCOLUMNS (
    SUMMARIZE (
        MASTERTABLE,
        MASTERTABLE[POSTAL_CODE],
        MASTERTABLE[DIENST],
        MASTERTABLE[POSTALCODE_DIENST]
    ),
    "PAK_VOL_REEL", CALCULATE ( AVERAGE ( MASTERTABLE[PAK_VOLUME_REEL] ) ),
    "PAK_VOL_ORG", CALCULATE ( AVERAGE ( MASTERTABLE[PAK_VOLUME_ORG] ) ),
    "EE_VOL_ORG", CALCULATE ( AVERAGE ( MASTERTABLE[EE_INDIV_ORG] ) ),
    "EE_VOL_REEL", CALCULATE ( SUM ( MASTERTABLE[EE_INDIV_REEL] ) ),
    "ENA_VOL_ORG", CALCULATE ( AVERAGE ( MASTERTABLE[ENA_VOLUME_ORG] ) ),
    "ENA_VOL_REEL", CALCULATE ( SUM ( MASTERTABLE[ENA_VOLUME_REEL] ) ),
    "FNGF_VOL_ORG", CALCULATE ( AVERAGE ( MASTERTABLE[FNGF_VOLUME_ORG] ) ),
    "FNGF_VOL_REEL", CALCULATE ( SUM ( MASTERTABLE[FNGF_VOLUME_REEL] ) ),
    "KRANT_VOL_ORG", CALCULATE ( AVERAGE ( MASTERTABLE[KRANT_VOLUME_ORG] ) ),
    "KRANT_VOL_REEL", CALCULATE ( SUM ( MASTERTABLE[KRANT_VOLUME_REEL] ) )
)

[Vanessa250919]

Hey ! thanks ! 

It's ok it's working, but I try to have the same resulte in this table then in this measure :

FNGF_VOLUME_ORG_AVG = SUMX(MASTERTABLE,MASTERTABLE[FNGF_VOLUME_ORG]) /COUNTX(MASTERTABLE,MASTERTABLE[DAY_DATE]) * DISTINCTCOUNT(MASTERTABLE[RONDE_NR])

This measure give me a correct result, I can have same result in Pivot