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/20...
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")
I think the issue is my data model date connection, but it seems correct, but obvisouly the table is showing otherwise.
Hi,
Share the link from where i can download your PBI file.