Forum Discussion
Solved
Avoiding Duplicate counts question
I have the below table and would like to visualize the following: To calculate the number of unique Technical IDs in relation to Process A and Process B. For example, there are 6 SAS 234s in rela...
Hi Tech325
In Power query, add a custom column below
Then modify measure
Measure = CALCULATE(COUNT(Query1[Process]),FILTER(Query1,[Text After Delimiter]=BLANK())) Measure 2 = SUMX(ALL(Query1[Nature of Business]),[Measure])Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
