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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 
You can use

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