Forum Discussion

tebtim19's avatar
tebtim19
Helper IV
5 years ago
Solved

Date Sortfo

Is anyone here know how to sort date for my slicer. Doesn't look like sorted  
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello tebtim19 ,

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello tebtim19 ,

Try this 

males = CALCULATE(COUNTROWS(FILTER(SAP Table,SAP Table[Gender]="Male")),ALLSELECTED(Dates[Year Month]))
 
tebtim19's avatar
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.