Solved: Re: Calculated Column with Grouping

Anonymous · ‎12-06-2018

Hi. I'm trying to create a Yes/No Column based on the evaluation on a single "training" Column; while grouping on two other columns -- ID and Year.

The End User Question would be: Did Jimmy (ID 1001) receive training in 2017; in 2018?

TY!

Dan

AlexisOlson · ‎12-06-2018

You want to remove the quarter context, but keep UserID and Year:

Results =
IF (
    CALCULATE (
        MAX ( Table1[Training] ),
        ALLEXCEPT ( Table1, Table1[UserID], Table1[Year] )
    )
        = "Yes",
    "Yes",
    "No"
)

View solution in original post

AlexisOlson · ‎12-06-2018

You want to remove the quarter context, but keep UserID and Year:

Results =
IF (
    CALCULATE (
        MAX ( Table1[Training] ),
        ALLEXCEPT ( Table1, Table1[UserID], Table1[Year] )
    )
        = "Yes",
    "Yes",
    "No"
)