Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Help with total average of average by category

Hello, guys! 

 

Need to make the solid measure of average value in each row.

 

How its now:

 

Average by dayWeekDayName
11240Monday
11041Tuesday
9830Wednesday
10858Thusday
11577Friday
14540Saturday
13735Sunday
11832 

 

How it should be:

 

Average by dayWeekDayName
11832Monday
11832Tuesday
11832Wednesday
11832Thusday
11832Friday
11832Saturday
11832Sunday
11832 

 

So, I just need exclude WeekdayName influence to calculation.

 

Thank you for your time.

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

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.

View solution in original post

6 REPLIES 6
Icey
Community Support
Community Support

Hi @Anonymous ,

 

Is this problem solved?

 

 

Best Regards,

Icey

Anonymous
Not applicable

Hi, Icey. Sorry for last reply.

Yes, solver.

Via (..., allselected ())

az38
Community Champion
Community Champion

@Anonymous 

smth like

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

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn
Anonymous
Not applicable

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

 

Icey
Community Support
Community Support

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
Super User
Super User

@Anonymous ,

Try like

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.