Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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. |
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. |
Thank you so much
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |