Forum Discussion

SushmaReddy's avatar
SushmaReddy
Icon for Helper I rankHelper I
4 years ago
Solved

Count without duplicates

Hi Team,      I got a requirement where i have to get the latest material count without duplicates based based on date field.       Max Date = Var mat= T1[Model Number] return MAXX( FILTER(A...
  • BeaBF's avatar
    BeaBF
    4 years ago

    SushmaReddy Try with:

     

    Misura =
    VAR MAXD = CALCULATE(MAX(Tabella[Date]), ALLEXCEPT(Tabella,Tabella[Model Number]))
    RETURN CALCULATE(DISTINCTCOUNT(Tabella[Model Number]), Tabella[Date] = MAXD, ALLEXCEPT(Tabella,Tabella[Model Number]))
     
    BF
BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
4 years ago

SushmaReddy Try with:

 

Misura =
VAR MAXD = CALCULATE(MAX(Tabella[Date]), ALLEXCEPT(Tabella,Tabella[Model Number]))
RETURN CALCULATE(DISTINCTCOUNT(Tabella[Model Number]), Tabella[Date] = MAXD, ALLEXCEPT(Tabella,Tabella[Model Number]))
 
BF