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

Why you add VALUES ( 'Date'[Date].[Month] ) in your DAX? Date and customer table have a relationship?

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi, 

 

yes, they have. table "date" is my calender table. 
I used VALUES, because it does work for another table. Happy to know how it could work with something else