How can I apply this formula to a column without it being summed in the values?

[sabby123]

Hello! I'm relatively new to Power BI Desktop and I'm looking to apply a simple formula to a column (since I'm not quite sure how to do it as a measure 😅).

The formula I used:
Group Mask Calculation = IF ( [Group Mask Group] = "4 & below", sum('Balance Sheet'[Credit Amount])-sum('Balance Sheet'[Debit Amount]), sum('Balance Sheet'[Debit Amount])-sum('Balance Sheet'[Credit Amount]) )

[v-cgao-msft]

Hi @sabby123 ,

In Power BI, the measure returns a scalar value, so it is usually not accepted as a column by the visual. (because it cannot be grouped other values)
If possible, try creating calculated columns.
If the provided solution doesn’t address your query, consider sharing non-private sample data and the expected outputs. This additional information could be beneficial in resolving the question.
How to provide sample data in the Power BI Forum

Best Regards,
Gao
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!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum