Multiple Columns Error

Hi Lamarandteddy ,

Thanks for the reply from lbendlin  Ashish_Mathur , please allow me to provide another insight.

Please try:

BudgetValuesOver100K = 
FILTER(
    SUMMARIZE(
        FILTER(
            'FP&A Metrics'.
            'FP&A Metrics'[Exercise Type] = "Budget"
        ),
        'FP&A Metrics'[Month].
        "TotalValue", SUM('FP&A Metrics'[Value])
    ),
[TotalValue] > 10000
)

This is the original data table:

This is the data table created by New Table, showing data for months where [TotalValue] > 10000.

The data you provided has only one month and the Month type is not Date, please note this in your original data table.

Please change [TotalValue] > 10000 to [TotalValue] > 444000.

The pbix file is attached.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!