joshua3mFrequent Visitor3 years agoSolvedCount Table Distinct Hello, I'm trying my journey with dax and i step into issue which i can't find a solution... I have table with CityLocation and Value and want count number of CityLocation where value is > 0. ...Show Moretamerj1 to joshua3m3 years agojoshua3m I can assume from your code that Value is a measure. In this case please try COUNT = COUNTROWS ( DISTINCT ( SELECTCOLUMNS ( FILTER ( VALUES ( 'Table'[CITYLOCATION] ), [VALUE] > 0 ), "City", LEFT ( 'Table'[CITYLOCATION], LEN ( 'Table'[CITYLOCATION] ) - 1 ) ) ) )
tamerj1 to joshua3m3 years agojoshua3m I can assume from your code that Value is a measure. In this case please try COUNT = COUNTROWS ( DISTINCT ( SELECTCOLUMNS ( FILTER ( VALUES ( 'Table'[CITYLOCATION] ), [VALUE] > 0 ), "City", LEFT ( 'Table'[CITYLOCATION], LEN ( 'Table'[CITYLOCATION] ) - 1 ) ) ) )
tamerj1 to joshua3m3 years agojoshua3m I can assume from your code that Value is a measure. In this case please try COUNT = COUNTROWS ( DISTINCT ( SELECTCOLUMNS ( FILTER ( VALUES ( 'Table'[CITYLOCATION] ), [VALUE] > 0 ), "City", LEFT ( 'Table'[CITYLOCATION], LEN ( 'Table'[CITYLOCATION] ) - 1 ) ) ) )
tamerj1Community Champion3 years agoHi joshua3m Please try Count = CALCULATE ( DISTINCTCOUNT ( 'Table'[CityLocation] ), 'Table'[Value] > 0 )
Related contentcount distinctDistinct CountDistinct countDAX Calculation for Distinct CountAverage - Distinct Count
