Average visible values, each column (as a row)

• Type: Inserted as a row
• Description: Calculates the average of all visible values in each column.
• Range:
  • Columns: Each column
  • Rows: All rows (visible)
  • Measures: Each measure
• Syntax:

avg(0, all(v), 0)

• Sample crosstab:

Examples

In a standard crosstab, like the one above, you might choose to hide data based on value using a visibility agent.

Here, we choose to hide every salesperson who at some point had less than 100 Sales per year.

Choose properties, visibility agents, and pick Hide member

Now choose the measure No of Sales

Set th condition to value < 100

Now one of the rows has been hidden based on this condition:

Adding to average, visible as a row will create this result (notice the average applies to total, each year and each measure):