topic Re: Countax minimum number of occurence in DAX Commands and Tips

Countax minimum number of occurence

dannytan1112 — Tue, 03 Jan 2023 08:38:08 GMT

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

Re: Countax minimum number of occurence

AlB — Tue, 03 Jan 2023 08:48:18 GMT

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.

Re: Countax minimum number of occurence

dannytan1112 — Tue, 03 Jan 2023 08:58:17 GMT

Thank you so much