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
saurabh_kedia_'s avatar
saurabh_kedia_
Microsoft Employee
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
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thank you it work, didn't know before the all except!! :)