Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
We wants to know the number of duplicates
Nb Duplicates =
VAR tabgrp =
SUMMARIZECOLUMNS (
'Client'[Nom];
Client[Prénom];
Client[Date_naissance];
"nb"; DISTINCTCOUNT ( Client[Id_Origin] ) )
VAR f = FILTER(tabgrp;[nb]> 1)
RETURN CALCULATE(COUNTROWS(tabgrp);f)
But f = FILTER(tabgrp;[nb]> 1) don t work
Thanks for your help.
Solved! Go to Solution.
Hi @Cobra77 ,
Try this small modification. Bear in mind that variables in DAX are immutable once they've been assigned a value at declaration. Therefore, tabgrp will not be affected by the filter argument in CALCULATE(COUNTROWS(tabgrp); f)
Nb Duplicates = VAR tabgrp = SUMMARIZECOLUMNS ( 'Client'[Nom]; Client[Prénom]; Client[Date_naissance]; "nb"; DISTINCTCOUNT ( Client[Id_Origin] ) ) VAR f = FILTER ( tabgrp; [nb] > 1 ) RETURN COUNTROWS ( f )
Hi @Cobra77 ,
Try this small modification. Bear in mind that variables in DAX are immutable once they've been assigned a value at declaration. Therefore, tabgrp will not be affected by the filter argument in CALCULATE(COUNTROWS(tabgrp); f)
Nb Duplicates = VAR tabgrp = SUMMARIZECOLUMNS ( 'Client'[Nom]; Client[Prénom]; Client[Date_naissance]; "nb"; DISTINCTCOUNT ( Client[Id_Origin] ) ) VAR f = FILTER ( tabgrp; [nb] > 1 ) RETURN COUNTROWS ( f )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |