Average function in Calculation Context

[Former Member]

Hi,

I am struggling with solution for past few days. I have a measure variable, company name and region in the report. I want to look at average of the measure at region wise(for all the companies). But the average value is not correct. When I add Company name to the table I get the correct value. But the requirement is I don't want to see the company name in the table.

I cannot hide the company name dimension, that would give multiple lines instead of a single average row.

I used Average([Measure] foreach [Company Name]) but it did not work. I tried forall,foreach, in with multiple combinations but to no success. Can anyone help me with the resolution?

P.S: The Region is a grouping variable

Thank you,
Shravya

[amitrathi239]

instead of measure variable create dimension variable and try