Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

count value with filter

Hello,    i have a data table with the 3 colums and i hope to get the last one: Identification number travel date Reservation class TYPE HAZERTY 11/01/2019 BI 1st class HAZERTY 15/...
Need Help
  • saurabh_kedia_'s avatar
    saurabh_kedia_
    7 years ago
    Hi Jibril,
     
    Kindly try the below DAX, if it works accept this as solution & give kudos!
     
    Type =
    VAR Count_Flight = CALCULATE(DISTINCTCOUNT('A_R MALIN'[Reservation Class]),ALLEXCEPT('A_R MALIN','A_R MALIN'[Identification Number]))
    RETURN
    IF(Count_Flight>1,"Mix","1st Class")
     
    Regards,
    Saurabh
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Anonymous 

 

Seems you are just missing the earlier function

 

Column =
CALCULATE (
    DISTINCTCOUNT ( 'A_R MALIN'[Reservation class] ),
    FILTER (
        'A_R MALIN',
        'A_R MALIN'[identification number]
            = EARLIER ( 'A_R MALIN'[identification number] )
    )
)