Help with total average of average by category

[Anonymous]

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.

[Icey]

Hi @Anonymous ,

Is this problem solved?

Best Regards,

Icey

[Anonymous]

Hi, Icey. Sorry for last reply.

Yes, solver.

Via (..., allselected ())

[az38]

@Anonymous 

smth like

Measure = 
CALCULATE(AVERAGEX(Table, [Measure]), ALL(Table))

[Anonymous]

it use all values in a table. But the time slicer should make an influence on it.

[Icey · Accepted 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.

[amitchandak]

@Anonymous ,

Try like

calculate( AverageX(Values(Table[ WeekDayName]),[Average by day]),allexcept(Table,Table[WeekDayName]))