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, I have a table which I am trying to process to find out the sum of Input Values for distinct Linked Permit numbers.
I can't delete duplicates, because this is a part of other columns, where I need duplicates.
I am trying to do this and it does not work, how hard I tried.
Solved! Go to Solution.
@Anonymous
Do you mean the version with DISTINCT should sum only once the duplicate rows? When you talk about duplicates, is it the whole row (i.e. all columns) that are duplicated?
If all rows are duplicated, wouldn't the result you want just what you get now divided by two?
Try these measures, a variation of what you had:
Sum of all input values = sum(TEST[Input Value])
Number Of Duplicates = COUNTROWS(TEST)
Distinct sum = SUMX ( DISTINCT ( TEST[Linked Permit] ), DIVIDE ( [Sum of all input values], [Number Of Duplicates] ) )
Hi @Anonymous
What is the problem exactly? What is the result as opposed to your expected/required result?
The issue is that the result of those measures is literally the same, so no filtering is going on in regards of distinct values (Linked Permit). I think it's visible on the picture above.
@Anonymous
Do you mean the version with DISTINCT should sum only once the duplicate rows? When you talk about duplicates, is it the whole row (i.e. all columns) that are duplicated?
If all rows are duplicated, wouldn't the result you want just what you get now divided by two?
Try these measures, a variation of what you had:
Sum of all input values = sum(TEST[Input Value])
Number Of Duplicates = COUNTROWS(TEST)
Distinct sum = SUMX ( DISTINCT ( TEST[Linked Permit] ), DIVIDE ( [Sum of all input values], [Number Of Duplicates] ) )
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |