Sum of values where measure is greater than 1

[Anonymous]

I'm looking to sum the values of a measure called, "Occurence Count", were the measure exceeds the value of 1.

Table:

mail, Occurence Count

test@test.com, 34

mail@nomail.com, 57

actualemail@gmail.com, 1

The resulting value I need to display is (34+57)=91.

The last email value, only has a count of 1, so I would not want to add this to the sum.

Background Info:

Some background, I took the distinct values from a table containing email addresses so that the table only contains unique email addresses.

Distinct Email = DISTINCT(originaltable[Email])

I created a measure counting email addresses from the original table. I put the new table values up and selected the measure to display the above sample table.

Distinct Email Count = COUNT(originaltable[Email])

The measure occurence count just counts the number of times a value displays in the data set.

Let me know if there is a better way of doing this as well.

[V-pazhen-msft · Accepted solution]

@Anonymous 

Try create a summrized table:

Measure = 
var temptable = SUMMARIZE('originaltable','originaltable'[Email],"Count",COUNT('originaltable'[Email]))
Return SUMX(FILTER(temptable,[Count]>1),[count])

Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you this was helpful!

[Greg_Deckler]

This looks like a measure aggregation problem. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149