Help Pls - Summarizecolumns with multiple filter to be applied in 1 column

[ChadGalicia]

Good day!

As stated in the subject how can I Summarizecolumns with multiple filter to be applied in 1 column?

I am trying to figure out how can I achieve this. Please help.

Fact table has 2 rows with duplicate values and I am trying to remove it using dax-filter.

FamilyMap = (SUMMARIZECOLUMNS(FSalesAct[Famlea],FSalesAct[Family Code],FSalesAct[Leaderable Code],FSalesAct[Division Code],FILTER(FSalesAct,(FSalesAct[Famlea]<>"2263522600") || (FSalesAct[Famlea]<>"4089040999"))))

Currently I am getting error below.

"Column '' in Table '' contains a duplicate value '40890' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table."

Thanks in advance for your help.

[ChadGalicia]

Snap!

I just changed the || into && and my data set is alright again. Weird! tried it earlier and it didn't.

FamilyMap = (SUMMARIZECOLUMNS(FSalesAct[Famlea],FSalesAct[Family Code],FSalesAct[Leaderable Code],FSalesAct[Division Code],FILTER(FSalesAct,(FSalesAct[Famlea]<>"2263522600") && (FSalesAct[Famlea]<>"4089040999"))))

[v-shex-msft · Accepted solution]

HI @ChadGalicia ,

Current calculated columns not support to stored multiple columns/table. Please modify your expression to confirm it return singe result.(e.g. merge multiple column values to one)

DAX Error: The Expression Refers to Multiple Columns. Multiple Columns Cannot Be Converted to a Scal...

Regards,

Xiaoxin Sheng