Forum Discussion
Gender Balance %
Hello There,
I have the below visual in my desktop application powerbi, however i just need to show the evolution of female % month on month. Instead of numbers. I know i can filter out & remove male. But still how do i show the % evolution only for females?
For Example i just want to see 7.48% for Jan, 7.51% for Feb, 7.4% for Mar & 7.34% for April.
Appreciate your support please. Thanks.
measure = Var _Males = Calculate ( Counta(Table[worker]) , Table[gender] = "Male" ) Var _femaes = Calculate ( Counta(Table[worker]) , Table[gender] = "Female" ) Return Divide(_female,_male)
2 Replies
measure = Var _Males = Calculate ( Counta(Table[worker]) , Table[gender] = "Male" ) Var _femaes = Calculate ( Counta(Table[worker]) , Table[gender] = "Female" ) Return Divide(_female,_male)