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 M...
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.
Hello,
I am attaching the powerbi sample file in the below google drive link. If you need any more information kindly do let me know.
https://drive.google.com/file/d/1OtJr8v834Rg78J2OfAoG9_h6rlG5uQz7/view?usp=sharing
Thanks for your help.