Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
As we are Migrating the Dasboard reports from qlik View to PowerBI. Qlik View have ability to do the Grand total values as follows
SUM\AVG\% values at the Totals Mode Section in Qlik View. But in PowerBi is not Availble with This option.
Can any one has the Idea how we can over come from this. because My client is Asking for this.
Thanks all.
Solved! Go to Solution.
I'm not sure what is your expected visual, but we can use DAX measure to do SUM on the Average like below.
SUM_On_Average_Year_Measure_2 = SUMX ( VALUES ( Table1[Year] ), CALCULATE ( AVERAGE ( Table1[Sales] ), ALLEXCEPT ( Table1, Table1[Year] ) ) )
SUM_On_Average_Year_Measure = SUMX ( ALL ( Table1[Year] ), CALCULATE ( AVERAGE ( Table1[Sales] ), ALLEXCEPT ( Table1, Table1[Year] ) ) )
Best Regards,
Herbert
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |