Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Filter calculate table / summarize by aggregate function column

Hello, I created a table using CALCULATETABLE and SUMMARIZE, trying to count the number of people who answered my question more then once, but my code is not working:   Test Doubled hcps = var D...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Here is the answer: 

    Test Doubled hcps = COUNTROWS(
    FILTER(CALCULATETABLE(SUMMARIZE(
    'Calls Analsis',
    'Calls Analsis'[sm_id],
    'Calls Analsis'[QuestionID],
    "Total Answers",COUNTA('Calls Analsis'[Answer] )
    )),'Calls Analsis'[QuestionID]="i204" && [Total Answers]>1 ))
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Here is the answer: 

Test Doubled hcps = COUNTROWS(
FILTER(CALCULATETABLE(SUMMARIZE(
'Calls Analsis',
'Calls Analsis'[sm_id],
'Calls Analsis'[QuestionID],
"Total Answers",COUNTA('Calls Analsis'[Answer] )
)),'Calls Analsis'[QuestionID]="i204" && [Total Answers]>1 ))
FreemanZ's avatar
FreemanZ
Super User
3 years ago

struggled and figured it out by oneslef would be the best.