Forum Discussion

kheira's avatar
kheira
Frequent Visitor
5 years ago
Solved

count without duplicates

hi  i have two columns and i want to count how many product id in statmeent without duplicates production with the same id  how i can do that with dax?   
  • Anonymous's avatar
    Anonymous
    5 years ago
    Hello kheira 
    Count I want =
    VAR StatementCount =
    CALCULATE(
    DISTINCTCOUNT('Table'[Satement ID])
    )
    VAR ProductCount =
    CALCULATE(
    COUNT('Table'[Product ID]),
    ALL('Table'[Product ID])
    )
    RETURN
    ProductCount - StatementCount

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Hello kheira 
Count I want =
VAR StatementCount =
CALCULATE(
DISTINCTCOUNT('Table'[Satement ID])
)
VAR ProductCount =
CALCULATE(
COUNT('Table'[Product ID]),
ALL('Table'[Product ID])
)
RETURN
ProductCount - StatementCount

kheira's avatar
kheira
Frequent Visitor
5 years ago

thank you 😍