cancel
Showing results for
Search instead for
Did you mean:
Helper II

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 7
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper II

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
Super User III

Hi,

You can simply created another measure

=IF([ABC - MH (ABS)]>0,"Mismatch","Match")

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Helper II

I think the issue is my data model date connection, but it seems correct, but obvisouly the table is showing otherwise.

Super User III

Hi,

Share the link from where i can download your PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Super User III

Hi,

What are Val1 and Val2?  Share the base dataset (in a format that can be pasted in MS Excel).

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Anonymous
Not applicable

Use the function ABS() to get the absolute difference.

Abs Value Diff = ABS(Value1 - Value2)

Helpful resources

Announcements

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors