Measure that will keep column values in table and ignore any filters in that table. RRS feed

  • Question

  • I'm just trying create a measure that will keep showing all values even when a filters is applied on my 'Hierarchy Table'. What am I doing wrong here.
    OpCoName = CALCULATE(VALUES('Hierarchy Table'[OpCo_Name]),FILTER('Hierarchy Table', ALL('Hierarchy Table')))
    Error Message:
    MdxScript(Model) (457, 108) Calculation error in measure 'Measures Table'[OpCoName]: A table of multiple values was supplied where a single value was expected.
    Wednesday, May 8, 2019 11:15 PM

All replies

  • A measure needs to evaluate to a single scalar value, the VALUES() function can return 1 or more values depending on the filter context. (at the grand total level for example it returns all the distinct values in the column)

    Normally a measure would aggregate a numeric value.


    CALCULATE( Sum( Sales[Amount] ) , ALL( 'Hierarchy Table' ) )

  - please mark correct answers

    Thursday, May 9, 2019 1:49 AM