help with DAX SUMX

[lookieuk]

Hello!

I'm just starting out with DAX and Power BI. I've created a basic DAX measure where I calculate two columns after applying a filter on other columns.

My question is: Is there a way to use the result from the part cost measure and multiply it by another column value that has been filtered in the same way as the part cost measure?

my DAX code:

Parts Cost = CALCULATE(SUMX(FILTER(QuoteCostSheetLine,QuoteCostSheetLine[wb_ActivityCode] = "Parts"),QuoteCostSheetLine[Quantity] * QuoteCostSheetLine[wb_CostRate]))

[lbendlin]

Yeah, that code looks a little adventurous.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous · Accepted solution]

Hi @lookieuk 

Thanks for the reply from lbendlin .

The following is a test I did using sample data for your reference.

Measure:

Result = 
VAR _M1 = CALCULATE(SUM(financials[Profit]), FILTER('financials', [Country] = "Canada"))
VAR _M2 = CALCULATE(SUM(financials[Sale Price]), FILTER('financials', [Country] = "Canada"))
RETURN
_M1 * _M2

Output:

If the problem still exists, then as Lindlin said, you need to provide sample data and expected results based on the sample data so that we can better help you. Please remove any sensitive data in advance.

Best Regards,
Yulia Xu

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