Forum Discussion

Helper IV

5 years ago

Solved

Date Sortfo

Is anyone here know how to sort date for my slicer. Doesn't look like sorted

Anonymous
5 years ago
Hello tebtim19 ,

Sort Year Month column by Year Month# using sort by Column option

Helper IV

5 years ago

Hi Thank you this solve my problem.

I have one more thing to ask.

I am trying to get the total number of male current employees.

Males = COUNTROWS(FILTER('SAP Table'[Gender] = "Male"))

But everytime I filtered it with my year month slicer it doesn't seems to work.

I need to this so I could also get the Average of Male. Hopw you can help

Anonymous

Not applicable

5 years ago

Try this

males = CALCULATE(COUNTROWS(FILTER(SAP Table,SAP Table[Gender]="Male")),ALLSELECTED(Dates[Year Month]))

tebtim19
Helper IV
5 years ago
Hi Still doesn't work when I select 2021 Feb I only got 3 males, which is supposed to be 209. I think the only number counter is the count of male added, but what I need is the total number of male filtered by month year.