Filter table based on Calculated Measure(s), using DAX formulas

asjones 

Filter arguments within CALCULATE normally overwrite existing filters.

A consequence of this is that if one of the filter arguments overwrite filters on columns that are included within your visual, you will see the same value returned for each value of that column within the visual.

You can modify the behaviour of filter arguments so that they instead intersect with existing filters using KEEPFILTERS - possibly this will give you the value you expect.

Try rewriting your measure as:

Expense =
    VAR _Amount =
    CALCULATE(
        SUM ( Financial[Amount4] ) ,
              KEEPFILTERS ( ProjectMasterFile[Project_Type] >= 50 )
          )
    Return _Amount

Does this give the expected result? Please post backif needed.

Regards,

Owen