cancel
Showing results for
Did you mean:
Post Prodigy

## 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")```
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support

## Re: Calcultae and Filter DAx errror

Hi @Route11

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

Community Support

## Re: Calcultae and Filter DAx errror

Hi @Route11

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

Announcements

#### Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

#### MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

#### ‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors