Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Good afternoon,
I have a problem with the aggregation of a measure.
Below is an illustration of my data:
Because of the "type of product" column, when I use SUMX for the customers for the day, I get the following:
What I wish to achieve is this result:
I tried using AVERAGEX and it works correct, when I view it for a particular day, but when I try to see the oranges for the month, it does not show the correct answer.
Could anyone please help me with this dax?
Thank you very much in advance!
Solved! Go to Solution.
[# Customers] =
sumx(
summarize(
T,
T[date],
T[customers for the day]
),
T[customers for the day]
)
[# Customers] =
sumx(
summarize(
T,
T[date],
T[customers for the day]
),
T[customers for the day]
)
Thank you very much for the help!
User | Count |
---|---|
22 | |
14 | |
11 | |
7 | |
5 |
User | Count |
---|---|
24 | |
22 | |
20 | |
15 | |
10 |