Sum column total female owner only if column SME Name is distinct

[Anonymous]

I am trying to get the sum of the column "Total Female Owner" only if "SME Name" is distinct.

I need help. Thanks

[Anonymous]

Thanks it worked very well

[johnt75]

Try

Sum total female owners =
SUMX (
    SUMMARIZE ( 'Table', 'Table'[SME Name], 'Table'[Total Female Owners] ),
    'Table'[Total Female Owners]
)

[Anonymous]

Hello,

thanks for the support, this is what I am geting.. am I missing something?

[johnt75 · Accepted solution]

You're creating it as a new table, it should be a new measure.