Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average is not working

Hi,   I have the numbers of customers of two months and want to show the average.   This visual is the sum of customers with code:  customer[count_no] = IF(ISBLANK(customer[name]),BLANK(),...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    hi Anonymous 

    try like:

    count_AVG =
    VAR _AverageTable =
        ADDCOLUMNS (
            VALUES ( 'Date'[Date].[Month] ),
            "count",

     CALCULATE(COUNT ( customer[count_no] ))

    RETURN
        AVERAGEX( _AverageTable, [count] )

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Tell us more about how you use this measure. Do you use a slicer?VALUES ( 'Date'[Date].[Month] ) seems you want to calulcated the average within a monthy group. 
Can you show the underlaying data for a given example, please. It is very difficult to understand the probem. 
Do you check the interaction between slicer and bar chart? 

Did the measure change, if you change the slicer. Can you please check if 354 is the average for the complete year 2022. I think in your measure miss a ALLSELECT(). 
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    yes, date (year and month) is used as a slicer, that also change the measure.

    354 is always the sum of the selected months.

     

    My data looks like:

    NetamountMonthYearClientnoDatenamecustomer
    10,0011993253401.01.1993customer 11
    20,0011993347501.01.1993customer 21
    20,0011993347501.08.1993  
    30,0011993586601.06.1993customer 41
    30,0011993273501.02.1993  

     

    Does that help?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    yes, date (year and month) is used as a slicer, that also change the measure.

    354 is always the sum of the selected months.

     

    My data looks like:

     

    Does that help?