Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Thanks for your help,
with best regards
Kathrin
Solved! Go to Solution.
Hi, you can follow this pattern:
ComisionTotal-WithAverageinTotal = IF ( HASONEVALUE ( Table1[Name] ); [Comisión Total]; AVERAGEX ( VALUES ( Table1[Name] ); [Comisión Total] ) )
Regards
Victor
right click on the dersired column in the tools tab and select average
There is no average which I can choose - it looks like your picture :).
Hi, you can follow this pattern:
ComisionTotal-WithAverageinTotal = IF ( HASONEVALUE ( Table1[Name] ); [Comisión Total]; AVERAGEX ( VALUES ( Table1[Name] ); [Comisión Total] ) )
Regards
Victor
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |