Forum Discussion
Combine filters, Filter exception,
Hi all,
I want to show all tasks from a sellected month and the Delayed tasks from previous months.
Thanks!
| Month | Status | Task |
| January | Delay | A |
| January | On track | B |
| January | Done | C |
| March | Delay | D |
| March | Done | E |
| March | On track | F |
You should be able to do this:
Count Measure = VAR __Table = ADDCOLUMNS( 'Table', "__Selected",[Selected] ) RETURN COUNTROWS(FILTER(__Table,[__Selected] = 1))
8 Replies
- Greg_Deckler
Community Champion
You will need a month number column and then you could do this:
Selected = SWITCH(TRUE(), MAX('Table'[MonthNo]) = SELECTEDVALUE([MonthNo]),1, MAX('Table'[MonthNo]) < SELECTEDVALUE([MonthNo]) && [Status]="Delay",1, 0 )Hi Greg_Deckler,
Thanks for the reply!
It's not working here, is this correct?
&& [Status]="Delay"
Regards,
Lucas
- Greg_DecklerOh, if you are using this in a measure, you need to wrap that with an aggregation like && MAX([Status]="Delay"