topic Re: Getting rid of duplicates! in DAX Commands and Tips

Getting rid of duplicates!

cdawidow — Fri, 24 Jul 2020 14:46:33 GMT

As you see above the values for the same contract / catagory I am analyzing is the same but the total is right given the year (2020). I am thinking that the contract (the catagory) I am analyzing despite the name being different given the specific years (2018, 2019 etc) they are equal. Is there any way to get rid of these duplicates ??

Re: Getting rid of duplicates!

nandic — Fri, 24 Jul 2020 15:05:57 GMT

cdawidow ,
As started on previous topic, it is because of data and join between tables.

If join is by concatenated field (prdlin & " " & prodno), you can see that you have two rows matching that criteria.
If 2018/19 is redundant you can filter data in power query to only display contract which contains text "2019/20".
Other option is to have another (new) column in sales table based on which you will separate duplicated amount.

Cheers,
Nemanja

Re: Getting rid of duplicates!

AntrikshSharma — Fri, 24 Jul 2020 15:05:58 GMT

Difficult to figure out the issue without looking at the model and the DAX.

Re: Getting rid of duplicates!

lbendlin — Fri, 24 Jul 2020 15:07:01 GMT

can you show your data model and which table each of the columns are coming from?

Re: Getting rid of duplicates!

cdawidow — Fri, 24 Jul 2020 15:14:48 GMT

Ya I just did that, included a filter and it was easy enough! Thanks for your help !