Measure to identify text values who correspond to a value in another column

[android1]

Hi,

I have a column Fullname which contains people whoe are either male or female. The male/female is listed as text values in another column called gender. I need to seperate all the males & females. Not sure if a measure is even the best way to do this.

[Anonymous]

Have you tried:

Measure =
CALCULATE ( [Your Measure Expression Here], TableName[Gender] = "Male" )

Not sure if you're trying to count the number of males or females, but Calculate will allow you to modify the filter context.

You may also want to put [Gender] on either a slicer or an axis of a graph.  That will separate the two genders.

Maybe post what your final expected result is?

Best,

~ Chris

[android1]

Thanks Chris,

This is'nt working for me. I need all the names in column Fullname in  2 seperate columns, Male & Female. The names in Fullname have a coresponding value, male or female in column Gender. Thomas Yorke is identified as male in coumn Gender, Sarah Connor is Female.

[Sean]

@android1 Go to the Query Editor and follow the steps in the picture...

[android1]

Hi Sean,

I have a LIVE CONNECTION TO THE db SO UNFORTUNATELY THIS WONT WORK.

[android1]

Sorry about the CAPS, didn't realise it was on.

[v-sihou-msft]

@android1

Since you are using live connection, you can't do any modeling within Power BI Desktop, you have to do it in your data source. If it's also a tabular, you can add calculated columns like:

Male = IF(Table[Gender]="Male",Table[FullName],BLANK())

Female = IF(Table[Gender]="Female",Table[FullName],BLANK())

Regards,