cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Helper II

## distinc not equal with sum of monthly production

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

Thank you

Rgds

Aji

3 REPLIES 3
Super User

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``````
Helper II

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

Helper V

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