Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calcultae and Filter DAx errror

Hi Experts

 

Cannot see the error here. I am trying to filter on Product Franchise first then Calculate the result of the second filter on Reporting Hierarchy....

 

IDIS vAOP$ less CCC Part 1 = CALCULATE(
            [$NSvPY4% (NOE @ AOP Rate)], FILTER(
                    'Product','Product'[Product Franchise]="Continence & Critcal Care"),'Reporting Hierarchy'[ID-IS]="ID - INFUSION DEVICES")
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    Try this formula instead.

    This formula i use in a measure, if you'd like a column, plrase let me know.

    IDIS vAOP$ less CCC Part 1 =
VAR filter1 =
    CALCULATE (
        [$NSvPY4% (NOE @ AOP Rate)],
        FILTER ( 'Product', 'Product'[Product Franchise] = "Continence & Critcal Care" )
    )
RETURN
    CALCULATE (
        filter1,
        FILTER (
            'Reporting Hierarchy',
            'Reporting Hierarchy'[ID-IS] = "ID - INFUSION DEVICES"
        )
    )

    Best Regards

    Maggie

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous

    Try this formula instead.

    This formula i use in a measure, if you'd like a column, plrase let me know.

    IDIS vAOP$ less CCC Part 1 =
VAR filter1 =
    CALCULATE (
        [$NSvPY4% (NOE @ AOP Rate)],
        FILTER ( 'Product', 'Product'[Product Franchise] = "Continence & Critcal Care" )
    )
RETURN
    CALCULATE (
        filter1,
        FILTER (
            'Reporting Hierarchy',
            'Reporting Hierarchy'[ID-IS] = "ID - INFUSION DEVICES"
        )
    )

    Best Regards

    Maggie