Add fixed value to variable values

amgelain — Mon, 23 Oct 2023 16:40:04 GMT

Hello,

I need to add the fixed values per company to the variable values per company. I ask for help in creating the DAX formula.

Grateful.

Re: Add fixed value to variable values

123abc — Tue, 24 Oct 2023 06:13:11 GMT

It sounds like you want to create a DAX formula in Power BI or another similar data analysis tool to add fixed values to variable values for different companies. In DAX, you can use the SUMX function to iterate through a table and apply calculations. Here's a general outline of how you can create a DAX formula for this purpose:

Assuming you have a table with columns like "Company," "FixedValue," and "VariableValue," you can create a calculated column or a measure to calculate the sum of fixed and variable values per company.

Here's an example of how you can create a calculated column:

TotalValue = [FixedValue] + [VariableValue]

This formula creates a new column called "TotalValue" that adds the "FixedValue" and "VariableValue" for each row in your data.

If you want to calculate the total sum of these values for each company, you can create a measure using SUMX and SUMMARIZE:

TotalSum = SUMX(
SUMMARIZE(
YourTableName,
YourTableName[Company]
),
[FixedValue] + [VariableValue]
)

Replace "YourTableName" with the actual name of your table. This measure calculates the sum of fixed and variable values for each company in your table.

You can then use this measure in your reports to display the total sum of values per company.

Please adapt the DAX formula to your specific data structure and requirements. If you have a different data model or need more specific guidance, provide more details about your data structure, and I can assist you further.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

Re: Add fixed value to variable values

amgelain — Tue, 24 Oct 2023 22:36:46 GMT

Hello,

Your opinion was important for me to finalize the formula.

Grateful.

Re: Add fixed value to variable values

123abc — Wed, 25 Oct 2023 09:35:47 GMT

You are wellcome.

topic Re: Add fixed value to variable values in DAX Commands and Tips

Add fixed value to variable values

Re: Add fixed value to variable values

Re: Add fixed value to variable values

Re: Add fixed value to variable values