Forum Discussion
Counting Union/Duplicates in a table or multiple tables
you can write a measure as follows:
measure _dupicate_count := var tbl= summarize ( your_table , full_name ,"total" , [all duplicate])
return
sumx(tbl , total)
and this measure to a card.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
Solution SageHi Stavros2024
you can write a measure as follows:
measure duplicated := var tbl = summarize (your_table , State, "duplicated" , distinctcount(Cell Phone))
var tbl2 = summarize ( filter(tbl , duplicated >=2) , state)
return
countrows (tbl2)
this will be return count of duplicated cells in selected states in slicer.
If this post helps, then I would appreciate a thumbs up 👍 and mark it as the solution to help the other members find it more quickly.
Hi Selva-Salimi it is so close to what I need, ATM it's giving me a total (I think of the type of Contacts) by those who are in the number of states
Blanked out the names to for privacy
So the there are a bunch of names that are in 4 states that are duplicated, there are another bunch in 3 states
What's an easy way to get the total of them all? That is how do I sum the "All Duplicated" Column?
Thanks so much!!
- Selva-Salimi
you can write a measure as follows:
measure _dupicate_count := var tbl= summarize ( your_table , full_name ,"total" , [all duplicate])
return
sumx(tbl , total)
and this measure to a card.
If this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.