topic Re: Gender in DAX Commands and Tips

Gender

Anonymous — Tue, 22 Nov 2022 12:30:23 GMT

Hello !

I need help categorizing different numbers that tell what gender it is.

Ex:
0, woman
1, man
2, woman
3, man

etc

Is there any good way to create a new variable for it?

Re: Gender

DimaMD — Tue, 22 Nov 2022 14:01:56 GMT

Hi Anonymous try it

SWITCH( TRUE(), OR([#] = 0, [#] = 2), "woman", OR([#] = 1, [#] = 3), "man", "etc" )

Re: Gender

Anonymous — Wed, 23 Nov 2022 08:58:54 GMT

Hello again!

I don't really know what I'm doing wrong, but it doesn't seem to work, I've tried several different options

Gender2 = SWITCH(TRUE(),
OR(Data_renter[Gender_number] = 0, Data_renter[Gender_number]=2), "Female",
OR(Data_renter[Gender_number] = 4, Data_renter[Gender_number]=6), "Female",
OR(Data_renter[Gender_number] = 8, Data_renter[Gender_number]=10), "Female",
OR(Data_renter[Gender_number] = 1, Data_renter[Gender_number]=3), "Male",
OR(Data_tenant[Gender_number] = 5, Data_tenant[Gender_number]=7), "Male",
OR(Data_renter[Gender_number] = 9, Data_renter[Gender_number]=11), "Male")

What am I doing wrong ?

Re: Gender

DimaMD — Wed, 23 Nov 2022 12:05:27 GMT

Hi Anonymous What is the data type in the column? text or numeric?
Show the error you are getting, preferably with a screenshot
look at the attached file, maybe you will understand where you made a mistake

Re: Gender

DimaMD — Wed, 23 Nov 2022 12:39:00 GMT

Anonymous See also this file, I optimized the measure and gave 2 examples