DAX Calulate columns problem

Question

Hello,&nbsp;I'm brand new to Power BI and still learning about DAX and creating advanced models. I have a small problem. I have a model called Test, and I created two DAX measures. When I use them separately in the model, they work fine. Now I want to create a third DAX measure that subtracts noQuantity from yesQuantity, but when I add it to the dashboard, I get an error without any explanation.&nbsp;yesQuantity =&nbsp;CALCULATE(&nbsp; &nbsp; COUNTROWS('Test'),&nbsp; &nbsp; 'Test'[isCalculated] = "Yes")&nbsp;noQuantity = CALCULATE(&nbsp; &nbsp; COUNTROWS('Test'),&nbsp; &nbsp; 'Test'[isCalculated] = "No")&nbsp;netQuantity = [YesQuantity] - [NoQuantity]&nbsp;&nbsp;

bhanu_gautam · Answer

Marecki&nbsp;you should use the exact names of the measures yesQuantity and noQuantity as defined.

netQuantity = [yesQuantity] - [noQuantity]

marecki · Answer

Ye, of course i put names properly in PowerBI. Sorry for that, my mistake when writing post.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Marecki&nbsp;
&nbsp;
I did some tests, but unfortunately that I can't reproduce your issue, it works well in my side.

&nbsp;
If possible, could you please provide more&nbsp;raw data&nbsp;in your tables (exclude&nbsp;sensitive&nbsp;data) with&nbsp;Text&nbsp;format and your&nbsp;expected result&nbsp;with backend logic and special examples?&nbsp;It would be helpful to find out the solution. You can refer the following links to share the required info:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
And&nbsp;It is better&nbsp;if you can share a&nbsp;simplified&nbsp;pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
&nbsp;
Best Regards
Zhengdong XuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

v-sdhruv · Answer

Hi&nbsp;Marecki&nbsp;,Just wanted to check if you had the opportunity to review the suggestions provided?If the response has addressed your query, please&nbsp;accept it as a solution&nbsp;and give a&nbsp;'Kudos'&nbsp;so other members can easily find it.Thank You

v-sdhruv · Answer

Hi&nbsp;@Marecki&nbsp;,Just wanted to check if you had the opportunity to review the suggestions provided?If the response has addressed your query, please&nbsp;accept it as a solution&nbsp;and give a&nbsp;'Kudos'&nbsp;so other members can easily find it.Thank You

Forum Discussion

DAX Calulate columns problem

6 Replies

Related content

Subtraction calulation

Calulated column question

Logic problem?

Slider problems

FILTERING PROBLEM