Forum Discussion
Column not adding measures correctly
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]
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