Forum Discussion
Solved
DISTINCTCOUNT without unique values in a column
Dear all, I´m trying to solve following problem: I have a table of Process IDs, e.g.: Process ID CM001 CM001 CM002 CM002 CM003 CM004 CM004 By using the DISTINCTCOUNT function in a ...
Hi, Matej_SVK
I am not sure if I understood your question correctly, but please check the below picture and the sample pbix file's link down below.
distinct count excluding only once appearing =
VAR newtable =
SUMMARIZE (
FILTER (
SUMMARIZE ( 'Table', 'Table'[Process ID], "@result", COUNTROWS ( 'Table' ) ),
[@result] > 1
),
'Table'[Process ID]
)
RETURN
COUNTROWS ( newtable )https://www.dropbox.com/s/hkvxbr1u41soj8i/matej.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
