Countif based off of unique entries

[joshcomputer1]

I have a set of audits. Each one has a total score-  summary[total score].  I want to be able to count the number of scores that were above 90%. The only trick to this is that the data is unpivoted so I need to filter based on the only unique identifier which is the summary[ticket number].  I think I need this:

count of scores above 90% if the ticket number is unique. 

This formula gets me a count but because the total score column is duplicated, it is much higher than actual (almost 10x higher)

Goal of 90 = calculate(count(summary[total score]), summary[total score] >= .9)

[Ashish_Mathur]

Hi @joshcomputer1,

Try this

=CALCULATE(DISTINCTCOUNT(summary[total score]),summary[total score] >= .9)

Hope this helps.

[nickchobotar]

@joshcomputer1

Give this a try

=
CALCULATE (
    COUNT ( summary[total score] ),
    ALLEXCEPT ( summary, summary[Ticket Number] ),
    summary[total score] >= .9
)

[joshcomputer1]

Does not work. The number went up. It needs to be filtered by unique ticket number. 

[Zubair_Muhammad · Accepted solution]

Hi @joshcomputer1

Try this measure

Goal of 90 =
CALCULATE (
    COUNTROWS (
        SUMMARIZE ( Summary, Summary[Ticket Number], Summary[Total Score] )
    ),
    Summary[Total Score] >= .9
)

[nickchobotar]

Hi @joshcomputer1

Please post a data sample.

Thanks

[joshcomputer1]

There are many columns here, but you can see that the ticket number is redundant due to unpivoting the table. I just need the count if the ticket number value is unique.