Forum Discussion

Burak83_'s avatar
Burak83_
Regular Visitor
3 years ago

Count based on multiple criteria DAX

Hi Gents, I would like to count distinct values based on the combination of multiple columns.(In sample Location+Item+Status) I added my table as data model to count distinct values but it does not ...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Burak83_ 

Try to plot a table visual with columns:Location, Item, Status, and a measure like:
Distinct Count = COUNTROWS(TableName)
 
in case of issue, could you provide some sample data?