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,
I am not sure this is possible.
I have a table of values as shown in the image below. I would like the totals at the end of each column to be the average of the
values in each colum, ie all the totals should be divided by 5 as there are 5 rows and not averaged by just the active data.
In the second display, which is a drill-down for the last row of data below, I would like just the totals to be displayed for each column.
So in essence, I'm after column averages to take into account the number of rows, irrespective of if they have data or not and secondly, when I drill-down then the next level displays just the total for each column, no averaging.
Hope this makes sense!
Thanks,
Mark.
Hi @markr1,
>>I have a table of values as shown in the image below. I would like the totals at the end of each column to be the average of the
values in each colum, ie all the totals should be divided by 5 as there are 5 rows and not averaged by just the active data.
The total value is based on the calculation above rows, if you use the sum, the total will display all sum of rows above in each column, if you use average, it will display average rows. We can't design custom calculation for total row.
>>In the second display, which is a drill-down for the last row of data below, I would like just the totals to be displayed for each column.
We can decide the total row display or not. But can't set that matrix just display total except for other rows. You can create feature request here, Power BI product team will consider it if more people need it.
Thanks,
Angelia
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |