Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
Hi @Ajeck Please refer to attached sample file with the proposed solution.
VAR CurrentDate = MIN ( Table1[date] )
VAR CurrentCodes = VALUES ( Table1[kode Product] )
VAR PreviousCodes =
VALUES ( Table1[kode Product] ),
Table1[date] < CurrentDate,
ALLSELECTED ( )
VAR Result =
COUNTROWS ( EXCEPT ( CurrentCodes, PreviousCodes ) )
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
So ......, what should i modify with that sollution?
distincvalue = DISTINCT(distinc1)VAR totalvalue = CALCULATE(SUMX(tablename,SUM(distinc1),ALL(tablename)))RETURNtotalvalue
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.