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]
    )

     

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

Hi Anonymous 
Filter lets you test something for each row,

CountX takes a table first argument then counts the field.

Improved only =
COUNTX(
    Filter('Ass Table',[Post-test score] > [Pre-test score])
    ,[Assessment ID]
)