Forum Discussion

Vanessa250919's avatar
Vanessa250919
Icon for Helper V rankHelper V
5 years ago

DAX pivot Average

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]...
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

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's avatar
Vanessa250919
Icon for Helper V rankHelper V
5 years ago

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