Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |