Countax minimum number of occurence

[dannytan1112]

Let say i have a  SN column of the Table to use table contains the values "a", "a", "a", "b", "b", "c", "c", "c", "d", "e", "f", "g", "h", "h", "h", "h"

I want it to return number of SN with the occurence at least 3 times

a = 3 times ; c = 3 times ; h = 4 times

So i want to have return value of 3 

This is my measure 

=COUNTAX(
'Table to use',
SUMX(
FILTER('Table to use', 'Table to use'[SN] = EARLIER('Table to use'[SN])),
1
) >= 3
)

any ideas how to do it? Thanks

[AlB · Accepted solution]

Hi @dannytan1112 

Measure = 
VAR numAppearances_ = 3
RETURN
    COUNTROWS (
        FILTER (
            DISTINCT ( Table1[SN] ),
            CALCULATE ( COUNT ( Table1[SN] ) ) >= numAppearances_
        )
    )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[dannytan1112]

Thank you so much