Help with Dax

Hi AmandaHore ,

Thanks for all the reply!
And AmandaHore , here is my sample data:

You can use this DAXs to create two measures:

Total Effort Worked = 
CALCULATE(
    SUM('Table'[Effortworked]),
    ALL('Table'),
    'Table'[Project Number] = MAX('Table'[Project Number])
)

Written Off Amount = 
CALCULATE(
    SUM('Table'[Effortworked]),
    ALL('Table'),
    'Table'[OverrideType] = "WrittenOff" && 'Table'[Project Number] = MAX('Table'[Project Number])
)

This will cancel the effect of all possible filters (including filters and slicers) on the results. But I saw that you mentioned this sentence "If I apply to the filter it filters the whole table". If you have other filters or slicers that may be used, you need to modify these DAXs according to the fields involved. If possible, please tell me which fields you will apply to filter.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.