Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, guys!
Need to make the solid measure of average value in each row.
How its now:
Average by day | WeekDayName |
11240 | Monday |
11041 | Tuesday |
9830 | Wednesday |
10858 | Thusday |
11577 | Friday |
14540 | Saturday |
13735 | Sunday |
11832 |
How it should be:
Average by day | WeekDayName |
11832 | Monday |
11832 | Tuesday |
11832 | Wednesday |
11832 | Thusday |
11832 | Friday |
11832 | Saturday |
11832 | Sunday |
11832 |
So, I just need exclude WeekdayName influence to calculation.
Thank you for your time.
Solved! Go to Solution.
Hi @Anonymous ,
How about adding below expression into your [Average by Day] measure?
ALLSELECTED ( Table[WeekDayName] )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Is this problem solved?
Best Regards,
Icey
Hi, Icey. Sorry for last reply.
Yes, solver.
Via (..., allselected ())
@Anonymous
smth like
Measure =
CALCULATE(AVERAGEX(Table, [Measure]), ALL(Table))
it use all values in a table. But the time slicer should make an influence on it.
Hi @Anonymous ,
How about adding below expression into your [Average by Day] measure?
ALLSELECTED ( Table[WeekDayName] )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
Try like
calculate( AverageX(Values(Table[ WeekDayName]),[Average by day]),allexcept(Table,Table[WeekDayName]))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |