Forum Discussion
Count different comparison between a Measure and a Column
Hello,
I am trying to compare the output from a measure("CODE MEASURE") with a column value("CODE COLUMN").
I want to calculate the mismatch of each code on a daily basis, example: If "CODE MEASURE" has a value A but got output in "CODE COLUMN" as B, then count as 1. In the final result("COUNT RESULT"), I want the count of mismatch between each code on a daily basis.
Thanks for any help provided.
4 Replies
Hi Anonymous ,
To create measures as below.
Count = IF ( MAX ( 'Table'[Code column] ) <> [Code measure], 1, 0 )
Count result = CALCULATE ( SUMX ( 'Table', [Count] ), ALLEXCEPT ( 'Table', 'Table'[Code column] ) )Thank you for your reply.
The below image shows the output which I got from the measure which you sent. But in the Code Measure many values are not shown, like "A","D","M"
My code measure has values - A,B,C,D,M,S&P
Similarly my code column has values - A,B,C,D,M,S&P.
1)I want the logic as if my code measure was a "A", then how many counts it was mismatched as B, similarly how many counts it was mismatched as C and so on.
2)Next what if my code measure was a "B", then how many counts it was mismatched as A, similarly how many counts it was mismatched as C and so on.
The same above logic I want to apply for each value in code measure.
Thank you in advance for your help.Hi Anonymous ,
Kindly share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
