Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?

 

auditDateABCMHABC - MH (ABS)
10/12/2018497149710
10/13/20182115209718
10/14/20189529520
10/15/2018469946990
10/16/20186251624011
10/17/2018062456245
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

     

    You can simply created another measure

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

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

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        Hi,

         

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