Column not adding measures correctly

[NPatel12498]

Hi,

I have a table with many different columns that are calculated measures. In the following image, the calculation of all the measures (horizontally) should be $122.92 but instead it shows an incorrect number under the Direct Costs Plus OH.

The calculation is:

Direct Costs Plus O/H = [Total Direct Costs] + [Claimed OH Organizational] + [Claimed O/H Material Handling] + [Special Asset Acquisition Allocation] + [Claimed O/H In-House] + [NDF Recoveries] + [Adjustments AC]

It should be $122.92, not sure if my calculation is wrong or if it needs to be updated

Any help will be appreciated ! 

[NPatel12498]

Claimed OH Organizational

Claimed OH Organizational = 
CALCULATE(
	SUM('All Costs'[ACCT_BURDENED_COST]),
	'All Costs'[EXPENDITURE_TYPE] IN { "Organization OH Applied" }
)

Claimed O/H material handling

Claimed O/H Material Handling = 
CALCULATE(
	SUM('All Costs'[ACCT_BURDENED_COST]),
	'All Costs'[EXPENDITURE_TYPE]
		IN { "Material Handling OH Applied" }
)

Special Asset Acquisition Allocation

Special Asset Acquisition Allocation = 
CALCULATE(
	SUM('All Costs'[ACCT_BURDENED_COST]),
	'All Costs'[EXPENDITURE_TYPE]
		IN { "Special Asset Acquisition Allo" }
)

All of the measures use this type of formula. The only thing that changes is the expenditure type. I won't list all of them out.

The final calculation which is Direct Costs Plus OH takes the sum of those measures.

Direct Costs Plus O/H = [Total Direct Costs] + [Claimed OH Organizational] + [Claimed O/H Material Handling] + [Special Asset Acquisition Allocation] + [Claimed O/H In-House] + [NDF Recoveries] + [Adjustments AC]

[Anonymous]

Hi lbendlin ,thanks for the quick reply, I'll add more.

Hi @NPatel12498 ,

Regarding your question, could you provide a .pbx file that does not contain sensitive data or simple sample data? What is the dax expression for 'Total Direct Costs'? Generally speaking, the problem you are experiencing will not occur. More information is needed.

If you are unsure how to upload data please refer to

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Wenbin Zhou

[NPatel12498]

Hi,

[Total Direct Costs] + [Claimed OH Organizational] + [Claimed O/H Material Handling] + [Special Asset Acquisition Allocation] + [Claimed O/H In-House] + [NDF Recoveries] + [Adjustments AC]

All of the measures within the calculation above are filtered value measures. They take the sum of burdened costs filtered by a certain expenditure type. The filtered value measure is a quick measure and doesn't account for blanks. How do you suggest I do that?

I need the Direct Costs Plus O/H calclulation to take the sum of each measure. So that means taking the sum of each of the measures below... which means it should be a total of $122.92 since all the other measures = blank or 0.

[lbendlin]

How do you suggest I do that?

Add them to a table visual one by one. 

[lbendlin]

I have a table with many different columns that are calculated measures.

In general we are calling these things measures, as opposed to calculated columns.  

Please provide details on what your measures are computing, which filters are being used, and if the results include blanks.

For troubleshooting you will want to show the individual measure values, and then add them one by one to see where it breaks down.