Forum Discussion

cfosund's avatar
cfosund
Icon for Helper I rankHelper I
5 years ago
Solved

Table visual shows wrong average total with dax measure

Hi,  I'm having trouble getting the correct average total value in a table visual when I create the following DAX Measure:  Avg time in minutes = VAR Name1 = CALCULATE(AVERAGE('Timestamp'[Time...
DATEDIFF
DAX
measure
  • AlB's avatar
    AlB
    5 years ago

    cfosund 

    Try this new measure, based on the one you already have:

    Avg time in minutes TOT = 
AVERAGEX(DISTINCT(Timestamp[Event Id]), [Avg time in minutes])

    See your modified file attached

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

cfosund 

Try this new measure, based on the one you already have:

Avg time in minutes TOT = 
AVERAGEX(DISTINCT(Timestamp[Event Id]), [Avg time in minutes])

See your modified file attached

 

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

  • cfosund's avatar
    cfosund
    Icon for Helper I rankHelper I
    5 years ago

    Excelente AlB , that worked! Thank you so much.