Forum Discussion

Wasfiathhar's avatar
Wasfiathhar
Frequent Visitor
4 years ago
Solved

Filter with many condition - DAX

I have have follwoing Table, the Invoice number with Dr/Cr Column, need to filter the common colum where invoice number duplicated with Dr/Cr. need summery similar to Screen shot 02.

 

pls advcie how to perform the DAX Formula.

Screen shot 01

 

Screen shot 02

 

 

Need Help

9 Replies

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    4 years ago

    Drag and drop those columns to a Matrix viz, voilà, that's all.

    • Wasfiathhar's avatar
      Wasfiathhar
      Frequent Visitor
      4 years ago

      If I drag and drop other additional Column  with Dr/Cr also will be available. How we can remove. Correct me if I'm wrong

      • CNENFRNL's avatar
        CNENFRNL
        Community Champion
        4 years ago

        A simple measure is enough; but I don't bother to author a single measure if the thread initiator doesn't provide any mock dataset.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    4 years ago

    Hi,

    You can also solve this in the Query Editor using the Pivot Column feature.

    • Wasfiathhar's avatar
      Wasfiathhar
      Frequent Visitor
      4 years ago

      from this table need to find the invocies number with duplicate then both side with "Dr/Cr" to be filtered further. any idea how i can perform by DAX, need the exzpeprt solution,

      in my cases Power Query will not work, as individual colmn from differnt table merged.