DAX Help!

[Anonymous]

Hey, 

I have a table 


Country                   
Argentina
brazil
germany 
germany 
India 


Then i have other columns also in that table.

But what dax formel can i use if i just want to filter out like germany? But only germany, example it can count of many time germany have been in that partiuclar coulmn? And not jusing, page/report/visual level filters.. but a dax formel instead ? 

Thanx in advance

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

You can new a calculated table:

Table =
SUMMARIZE (
    FILTER ( Table, Table[Country] = "germany" ),
    Table[Country],
    "Count", COUNT ( Table[Country] )
)

Best regards,

Yuliana Gu

[Greg_Deckler]

Something like:

Measure = COUNTROWS(FILTER('Table',[Country]="germany"))