The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
10 | |
9 | |
6 | |
6 | |
5 |
User | Count |
---|---|
22 | |
14 | |
14 | |
9 | |
7 |