cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arojash Frequent Visitor
Frequent Visitor

Help to know the error with Calculate

I am following this example.

 

http://www.daxpatterns.com/abc-classification/

 

2016-12-21_11-29-00.png

 

When I compare the result I have difference and I don't know why?

 

2016-12-21_11-34-00.png

 

When I go to check it the source and I find this, I have a Column FDCODIGO with the same line two times, My problem is I don't understand why duplicate the result in the measure TotalProductos

 

 

2016-12-21_11-46-30.png

 

I hope somebody can help me to understand the error.

 

Sorry my English is bad.

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Help to know the error with Calculate

A calculated column is added to the data model

 

A measure is calculated when is add to a visual or when you use in a dax Formula.

 

A better explanation of his difference you can visit this:

 

https://projectbotticelli.com/knowledge/dax-calculated-columns-vs-measures-video-tutorial

 

http://www.microsofttrends.com/2015/11/02/power-bi-calculated-columns-vs-calculated-measures-an-exam...

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




6 REPLIES 6
Super User
Super User

Re: Help to know the error with Calculate

Do have relationship with any other table?

 

How about data in the source system?





Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




arojash Frequent Visitor
Frequent Visitor

Re: Help to know the error with Calculate

It is a only table, I want cumulative the column "ventas netas", When I used a Measure I don't have problem, it is when I create a column.

Same syntax with a Measure or a Column have different result

Super User
Super User

Re: Help to know the error with Calculate

@arojash

 

Is the Context where the  Dax Formula is evaluated.

 

In a Column if you have duplicates this consider all in the sum process.

 

Sin título.png




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




arojash Frequent Visitor
Frequent Visitor

Re: Help to know the error with Calculate

One question for newbies, what is the difference between Measure and column, I am sorry but I don't have the clear concept

Super User
Super User

Re: Help to know the error with Calculate

A calculated column is added to the data model

 

A measure is calculated when is add to a visual or when you use in a dax Formula.

 

A better explanation of his difference you can visit this:

 

https://projectbotticelli.com/knowledge/dax-calculated-columns-vs-measures-video-tutorial

 

http://www.microsofttrends.com/2015/11/02/power-bi-calculated-columns-vs-calculated-measures-an-exam...

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




arojash Frequent Visitor
Frequent Visitor

Re: Help to know the error with Calculate

Thank you.

 

Muchas gracias,

 

Saludos desde Costa Rica.