Can True / False Indicators Be Created Using Rows Instead Of Columns?

Hi krichmond ,

Please try this calculated column:

True_False =
VAR _ifexistst =
    SUMMARIZE (
        FILTER (
            mv_perfex,
            [Start Month] = EARLIER ( mv_perfex[Start Month] )
                && [clientid] = EARLIER ( mv_perfex[clientid] )
        ),
        [versiontype]
    )
RETURN
    IF ( "TEST" IN _ifexistst, TRUE (), FALSE () )

In what form would you like to find data with "Version_type" as "TEST"? You can create a measure and format it conditionally.

Color = IF(MAX('mv_perfex'[versiontype])="TEST","red","black")

Alternatively, you can place the [version_type] field on a slicer to filter the visual, or you can create a measure to place as shown in the following image.

Flag = IF( MAX('mv_perfex'[versiontype])="TEST",1,0)

If you have more detailed requirements for displaying "TEST", please mark the answer to this post as a solution and republish a post detailing your needs, thank you.

Best Regards,

Neeko Tang

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