My goal is to have a measure, specifically an average, calculate across the entire underlying data set per row when I have pivoted columns.
I can achieve this result if I check “Row Totals”. Additionally, I can do this with sum and pivot_row for number measures. However, I would like to add additional customization if needed so I need this in a table calc. Below is an example screenshot.