Forum Discussion
DAX Calculated Column Boolean Field - Double Amount Of Rows Expected Issue In Output Results
I would like a calculated Field to produce the "Type" field below in this context.
Date | Val1 | Val2 | Abs Value Diff | Type |
| 1/1/2018 | 5 | 4 | 1 | Mismatch |
| 1/2/2018 | 5 | 5 | 0 | Match |
| 1/3/2018 | 5 | 6 | 1 | Mismatch |
Here is the Calculated Column Formula I am currently using:
IF([Abs Value Diff] > 0,"MisMatch","Match")
My current output is producing these unwanted results:
| auditDate | ABS Value Diff | Type |
| 1/1/2018 | 0 | Match |
| 1/1/2018 | 1 | MisMatch |
| 1/2/2018 | 0 | Match |
| 1/2/2018 | 0 | MisMatch |
| 1/3/2018 | 0 | Match |
| 1/3/2018 | -1 | MisMatch |
7 Replies
Hi,
What are Val1 and Val2? Share the base dataset (in a format that can be pasted in MS Excel).
Hi Anonymous,
As Ashish_Mathur said, please share some sample data, and show us the calculated formula of Val1, Val2 and Abs Value Diff.
Regards,
Yuliana Gu
Thank you for your responses and help. Let me clarify and answer your questions.
1. The only calculated measure in table below is "ABC - MH (ABS)"
ABC - MH (ABS) = ABS(
sum('Table1'[ABC]) - sum('Table1'[MH])
)2. Add fields come from same table
How can I create a filter field (calculated column?) to view auditDates that have mismatched and matched counts?
auditDate ABC MH ABC - MH (ABS) 10/12/2018 4971 4971 0 10/13/2018 2115 2097 18 10/14/2018 952 952 0 10/15/2018 4699 4699 0 10/16/2018 6251 6240 11 10/17/2018 0 6245 6245 Hi,
You can simply created another measure
=IF([ABC - MH (ABS)]>0,"Mismatch","Match")
