Forum Discussion
Kristian_nho
Helper I
Helper IFilter out data in a measure without using the FILTER expression
Hello, I have written a measure that distinct counts customers if they have positive Sales data: Customer Count = CALCULATE( DISTINCTCOUNT( Customer[Customer ID] ), FILTE...
Kristian_nho , Try like
CALCULATE(
Countx(filter( values( Customer[Customer ID] ), [NetSales] > 0 ),[Customer ID]
))
amitchandak
Super User
Super UserKristian_nho , Try like
CALCULATE(
Countx(filter( values( Customer[Customer ID] ), [NetSales] > 0 ),[Customer ID]
))
Kristian_nhoHelper I
Helper IPerfect, that worked like a charm. Thank you