topic Re: DAX Calulate columns problem in DAX Commands and Tips

DAX Calulate columns problem

Marecki — Mon, 03 Mar 2025 12:00:11 GMT

Hello,

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.

yesQuantity =

CALCULATE(

COUNTROWS('Test'),

'Test'[isCalculated] = "Yes"

)

noQuantity =

CALCULATE(

COUNTROWS('Test'),

'Test'[isCalculated] = "No"

)

netQuantity = [YesQuantity] - [NoQuantity]

Re: DAX Calulate columns problem

bhanu_gautam — Mon, 03 Mar 2025 13:59:52 GMT

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

netQuantity = [yesQuantity] - [noQuantity]

Re: DAX Calulate columns problem

Marecki — Mon, 03 Mar 2025 14:14:33 GMT

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

Re: DAX Calulate columns problem

Anonymous — Tue, 04 Mar 2025 08:40:49 GMT

Hi Marecki

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

If possible, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? 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 It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

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

Re: DAX Calulate columns problem

v-sdhruv — Thu, 17 Apr 2025 10:54:15 GMT

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

Re: DAX Calulate columns problem

v-sdhruv — Sun, 20 Apr 2025 09:51:30 GMT

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

Re: DAX Calulate columns problem

v-sdhruv — Sun, 04 May 2025 08:13:14 GMT