Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calculation Groups (?) for discrepancies report

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's avatar
    Anonymous
    2 years ago

    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.

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.