Filter with many condition - DAX

[Wasfiathhar]

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

[Ashish_Mathur]

Hi,

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

[Wasfiathhar]

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.

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.

[Wasfiathhar]

Hi Ashish, kindly find the link

https://drive.google.com/file/d/1KZhC4oHdFeqDqZI5k27eiUFqAjreBxT3/view?usp=sharing

https://drive.google.com/file/d/1wG62m-IKp1K-rTM8y3zdYe60Z585Idad/view?usp=sharing

[Ashish_Mathur]

Hi,

You already have the visual that you want.  What additional requirement do you have?

[CNENFRNL · Accepted solution]

[CNENFRNL]

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

[Wasfiathhar]

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]

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.