Average Measure not wokring

[MaleneL]

Hallo

Once again, I have a problem.

I have at table looking simplified looks something like this:

Date	customer	Acount	number
31-12-2024	Customer 1	Acount 1	1
31-12-2024	Customer 1	Acount 2	1
31-12-2024	Customer 1	Acount 3	1
31-12-2024	Customer 1	Acount 4	1
31-12-2024	Customer 2	Acount 1	3
31-12-2024	Customer 2	Acount 2	3
31-12-2024	Customer 2	Acount 3	3

I have build this very simple measure:

AverageNumber =

    CALCULATE(

        CALCULATE(

            AVERAGE(Table[number])))

It is of course connected to calendar dimension :O)

For Customer 1 the result is

I would like it to be 1

And Customer 2

I would like it to be 3

What am I doing wrong?

Sincerely

Malene

[FBergamaschi]

Hi @MaleneL 

I have the correct result using your data

so:

1 - have you checked the data type of the column number?

2 - why do you write

AverageNumber =

    CALCULATE(

        CALCULATE(

            AVERAGE(Table[number])))

and not simply

AverageNumber =

            AVERAGE(Table[number])

?

my file is here for your reference

https://drive.google.com/drive/folders/1iE4KnVQ1uhv1W41XpsBCd6cBnSdzK_xb?usp=sharing

Thanks

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[MaleneL · Accepted solution]

FORGET THIS ONE - I FOUND OUT WHAT I HAVE DONE WRONG - WRONG DIMENSION USED