How to create measure out of column

Question

Hi,

Need help in the problem faced in PowerBi.

I have ProfitValue as measure in one table and LossValue as column in another table.

Now I need to add ProfitValue and LossValue.

How can convert the LossValue column as measure? Any logic would help!!

Comments

Aggregate the column to create a measure such as a sum, average, etc.

A column can be converted to measure by aggregating the column.

sales column can become measure using sum(sales).

Answer 1

To convert the LossValue column into a measure in Power BI, you can create a new measure that calculates the sum of the LossValue column. Here's the logic you can use:

1. Navigate to the table containing the LossValue column.
2. Click on "Modeling" in the top menu.
3. Click on "New Measure" from the ribbon.
4. Enter a name for your new measure (e.g., TotalLossValue).
5. In the formula bar, enter the following DAX formula:

DAX

Copy code

TotalLossValue = SUM('TableName'[LossValue])

Replace 'TableName' with the name of your table containing the LossValue column.

1. Press Enter to confirm the formula.

Now, you should have a new measure called TotalLossValue that calculates the sum of the LossValue column. You can use this measure along with your ProfitValue measure to calculate the total profit or loss in your Power BI reports.

Read Related FAQ

How to create action button in Power BI