Combine expression

[ishanahiya]

I want to create one expression that will accomplish all these things. Can you help?

Part I

I want to sum the populations in these States

Sum({<[States] = {'Iowa' , 'Delaware'}>}[Population]

Without this Gender

Sum({<[Gender] - = {'Male'}>}[Population])

Part II

Return No for this State instead of a Population value

If([States]='South Dakota','No',

Without this Gender

Sum({<[Gender] - = {'Male'}>}[Population])

Part III

Add both expressions together so the total does not sum to No and records with Gender Male do not display in the table.

[MayilVahanan · Accepted solution]

Hi @ishanahiya ,

Try like below

Part I: Sum({<[States] = {'Iowa' , 'Delaware'},[Gender] - = {'Male'}>}[Population])

Part 2:  If([States]='South Dakota','No', Sum({<[Gender] - = {'Male'}>}[Population]))

Part 3: 

If([States]='South Dakota','No', Sum({<[States] = {'Iowa' , 'Delaware'},[Gender] - = {'Male'}>}[Population]))