Skip to Content

Average function in Calculation Context


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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 15, 2017 at 12:29 PM

    instead of measure variable create dimension variable and try

    Add comment
    10|10000 characters needed characters exceeded