Combine expression

ishanahiya — Fri, 19 Mar 2021 04:06:23 GMT

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.

Re: Combine expression

MayilVahanan — Fri, 19 Mar 2021 07:08:39 GMT

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]))