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],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])

2 Replies

  • 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