cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Count of Filtered Counts

Good Evening,

I'm trying to write a DAX expression that counts the number of IDs that occur twice or more in a table.

For instance:

 ID A B C A B A

...should return 2 as both A and B occur twice or more in the column.  Thanks for your assistance.

3 REPLIES 3
Community Champion
``````=
COUNTROWS(
FILTER( VALUES( DATA[ID] ), CALCULATE( COUNTROWS( DATA ) ) > 1 )
)``````

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
Resolver I

Hi,

You can use this measure:

Mesm=
Var t = SUMMARIZE('Table','ID',"Cnt",CountRows('Table'))

Return

CountRows(FILTER(t,[Cnt] >=2))

And, after creating the measure, you can use a card and drag ( or dispaly) the measure on the card, and you'll see the count you are looking for.

Best regards.

Anonymous
Not applicable

Hello

Try this

Countdoubleormore = countrows(filter(summarize('Table','Table'[id],"@nb",COUNTA('Table'[id])),[@nb]>1))

measure

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.