Forum Discussion

darko861's avatar
darko861
Icon for Resolver II rankResolver II
5 years ago
Solved

Averagex based on filter condition

Hi all, I'm trying to calculate the average of a column (measure Rev_per_hour_1) from a visual table that has a filter applied on the column Rev_per_hour 3 (measure). Unfortunately, my measure ignor...
Need Help
  • darko861's avatar
    darko861
    5 years ago

    Hi,

     

    I managed to solve this issue by altering the measure that is in bold text:

     

    Average Rev 1 = AVERAGEX(VALUES(PivotTable[D2021_Foeretag]),[xxx_rev_per_hour1])

     

    The measure should look like this: 

    xxx_rev_per_hour1 = IF([xxx_rev_per_hour3]=BLANK(),BLANK(),DIVIDE([xxxrev1],[xxxrev1.0],BLANK()))
     
    And you will get the desired result.

     

     

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

 

Could you please try with below dax.

 

=CALCUATE(AVERAGEX(VALUES(PivotTable[D2021_Foeretag]),[xxx_rev_per_hour1]),KEEPFILTERS(customernamecolumn))

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

darko861's avatar
darko861
Icon for Resolver II rankResolver II
5 years ago

Hi,

this does not work, it gives an error

= CALCULATE(AVERAGEX(VALUES(PivotTable[D2021_Foeretag]),[xxx_rev_per_hour1]),KEEPFILTERS(PivotTable[D2021_Foeretag]))