distinc not equal with sum of monthly production

[Ajeck]

Hi every one,

I need a help,

i have the data with duplicate product code, then to annulir this i used a distinc so, the report table is like this : 

but when I add up, 4,829 + 3,715 + 3,420 + 3,205 is not 15,165.

SO i want the report table to be like this : 

what should I do with Dax to get what i want?

Here is the Pbix file 

https://www.dropbox.com/s/nlhqwyy33826lqn/tes%20unit%20distinct%202.pbix?dl=0 

Thank you

Rgds

Aji

[tamerj1]

Hi @Ajeck 
Please refer to attached sample file with the proposed solution.

distinc2 = 
VAR CurrentDate = MIN ( Table1[date] )
VAR CurrentCodes = VALUES ( Table1[kode Product] )
VAR PreviousCodes = 
    CALCULATETABLE ( 
        VALUES ( Table1[kode Product] ),
        Table1[date] < CurrentDate,
        ALLSELECTED ( )
    )
VAR Result =
    COUNTROWS ( EXCEPT ( CurrentCodes, PreviousCodes ) )
RETURN
    Result

[Ajeck]

Hi Tamerj1,

Thankyou for helping me,

Will this solution ( MIN (Table[date])  be problematic when the year period is more than 1 year ?

for example if there are same data in 2022 and 2023 so the report table will be :

the report table should be :

here is the file with added year 2022

https://www.dropbox.com/s/4474q23amga6otu/tes%20unit%20distinct%202%282%29.pbix?dl=0

So ......, what should i modify with that sollution?

Thank you

Rgds

Ajeck

[devanshi]

distincvalue = DISTINCT(distinc1)
VAR totalvalue = CALCULATE(SUMX(tablename,SUM(distinc1),ALL(tablename)))
RETURN
totalvalue