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,
This formula is not working, not sure where is the mistake. Could you help me ?
=CALCULATE(SUM(BR[Value]),
FILTER(BR,BR[BR Report]="Revenue"),FILTER(BR,BR[Type]="MTD Actual"))
I need to calculate the column "Value" but filtering by 2 categories from 2 different columns.
Thanks and regards.
Solved! Go to Solution.
Hi,
Please try this:
=
CALCULATE (
SUM ( BR[Value] ),
FILTER ( BR, BR[BR Report] = "Revenue" && BR[Type] = "MTD Actual" )
)
If you still have any issue, please share some sample data and the expected result.
Thanks!
Best Regards,
Giotto Zhi
Hi,
Yeah, if you want to filter many categories, you should add all of them into FILTER function by '&&'.
And you can also filter them in Filter Pane.
Best Regards,
Giotto
Hi,
Please try this:
=
CALCULATE (
SUM ( BR[Value] ),
FILTER ( BR, BR[BR Report] = "Revenue" && BR[Type] = "MTD Actual" )
)
If you still have any issue, please share some sample data and the expected result.
Thanks!
Best Regards,
Giotto Zhi
Hi @v-gizhi-msft ,
How can I filter more than 2 categories? like 4 catogories ?
=CALCULATE(SUM(BR[Value]),FILTER(BR,BR[BR Report]="9. TOTAL RESOURCE COST" && BR[BR Report]="12.2 Net Load / (Load Recoveries)" && BR[Type]="MTD Actual"))
I have to use: && everytime I add a filter ?
Thanks
Hi,
Yeah, if you want to filter many categories, you should add all of them into FILTER function by '&&'.
And you can also filter them in Filter Pane.
Best Regards,
Giotto
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.