Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Experts
I have the below report being used by the business. I was asked to populate the average of total sales of all stores of group A for a particular week.
I do not have date in my dataset, there is only weekyear, month and year.
Can anyone please help me with the DAX code to achieve the average sales for a particular week.
Thanks
Mahad
Solved! Go to Solution.
@Anonymous
Give this a try.
Avg =
CALCULATE (
AVERAGE ( YourTable[Sales] ),
ALLEXCEPT ( YourTable, YourTable[Week], YourTable[Group] )
)
@Anonymous
Give this a try.
Avg =
CALCULATE (
AVERAGE ( YourTable[Sales] ),
ALLEXCEPT ( YourTable, YourTable[Week], YourTable[Group] )
)
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |