Hi all, I have a data structure which looks like the below. Now I would like to have a measure that gives me the below result. When I would filter a department, I need to see the total hours of the project they were involved in. For Example, when I would filter Department A, I would need to see 700 hours (total hours of Factory X). Anybody who can point me to the right direction? Thank you in advance,Regards

Anonymous I wrote it according to the needs described in your sample......You didn't mention AJB4. If you want all to show 500, you just need to truncate part of my original formula. SUM ( 'WBS cost'[Cost] ) / CALCULATE ( SUM ( 'Allocation Key Hours'[Hours] ), ALL ( 'Allocation Key Hours' ) ), Best Regards, Community Support Team _Janey

need help on filter measure | Microsoft Fabric Community

Forum Discussion

Related content

Dynamic measure filtering

Filter by Rank measure

Using measure as a filter

Measure not affected by filter

DAX MEASURE TO FILTER