Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Count distinct values based on another column meeting a specific condition

Hello experts,   I am new on the forum and a newbie at PowerBi. So far I have managed to find answers to many of my questions through Google leading me here but I have been stuck trying stuff for t...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    You are absolutely correct Anonymous I missed that bit sorry.

    Here you go:

    Improved unique assid only =
    COUNTX(
        Distinct(SELECTCOLUMNs( Filter('Ass Table',[Post-test score] > [Pre-test score]),"AssId",[Assessment ID]))
        ,[AssId]
    )

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks so much for your quick response. 

 

However, I am unsure if the formula counts the unique assessment ID. Is it not counting the questions that have improved?  In your screenshot I see the same assessment ID twice. 

 

Thanks,

Susan

  • SamWiseOwl's avatar
    SamWiseOwl
    Icon for Super User rankSuper User
    2 years ago

    You are absolutely correct Anonymous I missed that bit sorry.

    Here you go:

    Improved unique assid only =
    COUNTX(
        Distinct(SELECTCOLUMNs( Filter('Ass Table',[Post-test score] > [Pre-test score]),"AssId",[Assessment ID]))
        ,[AssId]
    )