Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
rendalignacio
Helper I
Helper I

Incorrect matrix row total

‎10-20-2017 02:55 AM

Hi,

 

Can you please help me with this scenario?

 

The matrix row gives an incorrect average. Please see image:

 

Total row incorrect average.jpg

Labels:
Message 1 of 3
1,050 Views
0
1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

‎10-22-2017 11:08 PM

@rendalignacio,

 

You may use the following measure.

Measure =
IF (
    HASONEFILTER ( Table1[Test] ),
    AVERAGE ( Table1[Value] ),
    AVERAGEX (
        ALLSELECTED ( Table1[Test] ),
        CALCULATE ( AVERAGE ( Table1[Value] ) )
    )
)
Community Support Team _ Sam Zha
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

Message 3 of 3
1,189 Views
0
2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

‎10-22-2017 11:08 PM

@rendalignacio,

 

You may use the following measure.

Measure =
IF (
    HASONEFILTER ( Table1[Test] ),
    AVERAGE ( Table1[Value] ),
    AVERAGEX (
        ALLSELECTED ( Table1[Test] ),
        CALCULATE ( AVERAGE ( Table1[Value] ) )
    )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 3 of 3
1,190 Views
0
Bordalos
Helper I
Helper I

‎10-20-2017 03:48 AM

 

hi @rendalignacio,

 

Why are you saying that is wrong? Careful with average of averages as they are not the same of total average.

 

Does this make sense?

 

 

Capture1.PNG

Message 2 of 3
1,043 Views
0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All