Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Total Distinctcount on aggregate value

Hi there, I have been researching everywhere but I cannot find the same answer. Raw data: I have a table where the agent received a score based each Date. Date AgentName Score 1/05/2022 ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    You can use

    Pass/Fail = 
SUMX ( 
    SUMMARIZE ( 'Table', 'Table'[AgentName],'Table'[Date] ),
    CALCULATE (
        IF ( [Sum of Scores] > 25, 1 )
    )
)

Whitewater100's avatar
Whitewater100
Solution Sage
4 years ago

Hi:

You can try two calculated columns and one measure. Measure at bottom.

CC#1.
Total Score = CALCULATE(SUM('Table'[Score]), ALLEXCEPT('Table','Table'[AgentName]))
CC#2
Score < 25 = IF('Table'[Total Score] <= 25, 1,0)
Score Count = CALCULATE(DISTINCTCOUNT('Table'[AgentName]),'Table'[Score < 25] = 1)
I hope this helps!