Calculation Groups (?) for discrepancies report

[DmitryD77]

Hello community,

Please help, I need to create a data quality report. One of the steps is to create a discrepancy page:

When slicer is selected from the above, table must only display mismatches based on the measure: Measure X SX vs SX = FALSE.

The "New Visual Slicer" also requires conditional formatting (Format/Buttons/Fill) based on the "Measure X SX vs SX" results. If "Measure X SX vs SX" = FALSE, color = "red", TRUE, color = "green".

Also, the number of measures in DIFF folder in the real dataset is more than 40, so if by using "calculation groups" the number can be reduced, it will be perfect.

Link to the file.

[Anonymous · Accepted solution]

Hi @DmitryD77 ,

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.