Forum Discussion

KWelsh8144's avatar
KWelsh8144
Helper II
3 years ago
Solved

Calculated Column

I’m trying to set up a column that would be used as a flag, using conditionals.   I have an ‘informational’ table, and another table named ‘repeatable’. There is one record per record_id in my info...
Data Modeling
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi KWelsh8144 ,

     

    Like this?

    you can create one measure and one calculated column to meet your needs:

     

    sum = CALCULATE(SUM('Table'[follow up visit]),FILTER(ALL('Table'),'Table'[record id]=SELECTEDVALUE('Table'[record id])))

     

    Column = IF([sum]=BLANK(),"no follow up visits completed",IF([sum]=0,"first follow up visit completed",IF([sum]=1,"2nd follow up visit completed","all follow up visits completed")))

     

     

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi KWelsh8144 ,

 

Like this?

you can create one measure and one calculated column to meet your needs:

 

sum = CALCULATE(SUM('Table'[follow up visit]),FILTER(ALL('Table'),'Table'[record id]=SELECTEDVALUE('Table'[record id])))

 

Column = IF([sum]=BLANK(),"no follow up visits completed",IF([sum]=0,"first follow up visit completed",IF([sum]=1,"2nd follow up visit completed","all follow up visits completed")))

 

 

 

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly