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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KBO
MVP

How to show sub total as an average in matrix visualization?

Hi,

can anybody show me what I have to do If I want to show my sub total in a matrix visual as average? Is this possible in the matrix visual configuration or need I an measure or calculated column? 

Sub Tótal.png

Thanks for your help,

 

with best regards

Kathrin

 

1 ACCEPTED SOLUTION
Vvelarde
Community Champion
Community Champion

@KBO

 

Hi, you can follow this pattern:

 

 

ComisionTotal-WithAverageinTotal =
IF (
    HASONEVALUE ( Table1[Name] );
    [Comisión Total];
    AVERAGEX ( VALUES ( Table1[Name] ); [Comisión Total] )
)

Image2.png

 

Regards

 

Victor




Lima - Peru

View solution in original post

3 REPLIES 3
Hardik
Continued Contributor
Continued Contributor

right click on the dersired column in the tools tab and select averageScreenshot_17.png

There is no average which I can choose - it looks like your picture :).

 

 

Vvelarde
Community Champion
Community Champion

@KBO

 

Hi, you can follow this pattern:

 

 

ComisionTotal-WithAverageinTotal =
IF (
    HASONEVALUE ( Table1[Name] );
    [Comisión Total];
    AVERAGEX ( VALUES ( Table1[Name] ); [Comisión Total] )
)

Image2.png

 

Regards

 

Victor




Lima - Peru

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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