cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kevthebandit Regular Visitor
Regular Visitor

DAX - Calculated Column Boolean Field - Unexpected Results

I am attempting to create a boolean calculated column "Type" below:

 

DateVal1Val2Abs Value DiffType
1/1/2018541Mismatch
1/2/2018550Match
1/3/2018561Mismatch

 

My current calculation is below, and it is outputing the following results: What am I doing wrong to get double the amount of rows expected in this case?

 

Type = IF(sum(ABS Value Diff) > 0,"MisMatch","Match")

 

auditDateABS Value DiffType
1/1/20180Match
1/1/20181MisMatch
1/2/20180Match
1/2/20180MisMatch
1/3/20180Match
1/3/20181MisMatch
1 REPLY 1
Community Support Team
Community Support Team

Re: DAX - Calculated Column Boolean Field - Unexpected Results

Hi @Kevthebandit,

 

It seems the [auditDate] and [Type] are in two different data tables. Do they have a proper relationship? Can you share a sample?

 

 

Best Regards,
Dale

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