topic Re: Sum column total female owner only if column SME Name is distinct in DAX Commands and Tips

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

Anonymous — Mon, 03 Apr 2023 09:31:37 GMT

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

I need help. Thanks

johnt75 — Mon, 03 Apr 2023 10:28:37 GMT

Try

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

Anonymous — Mon, 03 Apr 2023 11:21:41 GMT

Hello,

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

johnt75 — Mon, 03 Apr 2023 11:25:58 GMT

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

Anonymous — Mon, 03 Apr 2023 13:55:37 GMT

Thanks it worked very well