Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))
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]))