Forum Discussion
Filtering by Dimension
Hi, FuriousDawg33
If you're trying to aggregate total costs filtered by department, you might consider using a DAX measure to calculate this value. You can refer to the following DAX
Total Expenses by Department = CALCULATE(SUM('Financial Statements'[Amount]), 'DimensionSet Entries'[Department] = "YourDepartment")If your model needs to be filtered across multiple tables, and the filters aren't propagating as expected, look at the filter direction in the relationship. Sometimes it helps to set up a relationship with two-way filtering, but use this feature with caution as it can lead to unexpected results in complex models. More information about two-way filtering:
Bidirectional cross-filtering in Power BI Desktop - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, FuriousDawg33
If you're trying to aggregate total costs filtered by department, you might consider using a DAX measure to calculate this value. You can refer to the following DAX
Total Expenses by Department = CALCULATE(SUM('Financial Statements'[Amount]), 'DimensionSet Entries'[Department] = "YourDepartment")
If your model needs to be filtered across multiple tables, and the filters aren't propagating as expected, look at the filter direction in the relationship. Sometimes it helps to set up a relationship with two-way filtering, but use this feature with caution as it can lead to unexpected results in complex models. More information about two-way filtering:
Bidirectional cross-filtering in Power BI Desktop - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.