Evaluate ADDCOLUMNS( UNION ( // To validate the Raw dataset name rows ROW ( "Test Name", "Raw dataset name: Rows", "Expected Value", frame size, "Actual Value", Countrows('Raw dataset name') ) , // To validate the Sample dataset name rows ROW ( "Test Name", "Sample dataset name: Rows", "Expected Value", sample size, "Actual Value", Countrows('Sample dataset name') ) , // To validate the Raw dataset name distinct Segment1 ROW ( "Test Name", "Raw dataset name: Distinct Segment1", "Expected Value", number of distinct values in segment1, "Actual Value", DISTINCTCOUNT('Raw dataset name' [Segment1]) ) , // To validate the Sample dataset name distinct Segment1 ROW ( "Test Name", "Sample dataset name: Distinct Segment1", "Expected Value", number of distinct values in segment1, "Actual Value", Distinctcount('Sample dataset name' [Segment1]) ) , // To validate the Raw dataset name distinct Segment2 ROW ( "Test Name", "Raw dataset name: Distinct Segment2", "Expected Value", number of distinct values in segment2, "Actual Value", DISTINCTCOUNT('Raw dataset name' [Segment2]) ) , // To validate the Sample dataset name distinct Segment2 ROW ( "Test Name", "Sample dataset name: Distinct Segment2", "Expected Value", number of distinct values in segment2, "Actual Value", Distinctcount('Sample dataset name' [Segment2]) ) ), "Test Failed", IF ([Expected Value] <> [Actual Value], "Yes", Blank() ) )