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

     

Sourav_M's avatar
Sourav_M
Frequent Visitor
2 years ago

Hi Anonymous ,

Please use this DAX query:

Improved_Count =
VAR _temp =  SUMMARIZE(Sheet1,Sheet1[Assesment ID],"TotalPreScore",SUM(Sheet1[Pre-Test Score]),"TotalPostScore",SUM(Sheet1[Post-Test Score]))
RETURN
    COUNTX(
    Filter(_temp, [TotalPostScore] > [TotalPreScore])
    ,[Assesment ID]
)