Forum Discussion
Average Measure not wokring
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
FORGET THIS ONE - I FOUND OUT WHAT I HAVE DONE WRONG - WRONG DIMENSION USED
2 Replies
FORGET THIS ONE - I FOUND OUT WHAT I HAVE DONE WRONG - WRONG DIMENSION USED
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
