Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm having trouble comparing columns that are in two different tables. In the image below, I want to compare Expected Base Loss and Base Loss. If the two numbers match, then I want Base Loss Accuracy to read Yes, if they don't then it should read No.
This is what I currently have in the function
Please check that your numbers aren't being summarised (e.g. SUM, AVERGE, etc).
I suspect that your SELECTEDVALUE() is returning blanks because there might be more than 1 value for 'Service'[Base Loss] and 'Valu-Rite'[Expected Base Loss] per row.
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |