Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
81 | |
65 | |
62 |
User | Count |
---|---|
147 | |
116 | |
104 | |
88 | |
65 |