Calculation Groups (?) for discrepancies report

Hi Anonymous ,

You can put these fields in a table to determine if they are equal.

Create measure.

MEASURE = 

VAR _cur =

    MAX ( 'Indicators (Group)'[Indicators (Group)] )

VAR _color =

    SWITCH (

        TRUE (),

        _cur = "Measure 1 S1 vs S2", 'Calculations'[Measure 1 S1 vs S2],

        _cur = "Measure 1 S1 vs S3", 'Calculations'[Measure 1 S1 vs S3],

        _cur = "Measure 2 S1 vs S2", 'Calculations'[Measure 2 S1 vs S2],

        _cur = "Measure 2 S1 vs S3", 'Calculations'[Measure 2 S1 vs S3],

        FALSE ()

    )

RETURN

    IF ( _color = FALSE (), 0, 1 )
 

You can create rules for the selected state of a button to show different colours.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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