topic Re: Combine filters, Filter exception, in DAX Commands and Tips

Combine filters, Filter exception,

Anonymous — Tue, 24 Mar 2020 18:17:41 GMT

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

Re: Combine filters, Filter exception,

Greg_Deckler — Tue, 24 Mar 2020 19:26:27 GMT

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 )

Re: Combine filters, Filter exception,

Anonymous — Thu, 26 Mar 2020 13:08:03 GMT

Hi Greg_Deckler,

Thanks for the reply!

It's not working here, is this correct?

&& [Status]="Delay"

Regards,

Lucas

Re: Combine filters, Filter exception,

Greg_Deckler — Thu, 26 Mar 2020 13:56:08 GMT

Oh, if you are using this in a measure, you need to wrap that with an aggregation like && MAX([Status]="Delay"

Re: Combine filters, Filter exception,

Anonymous — Thu, 26 Mar 2020 18:56:14 GMT

Greg_Deckler,

Thank you it worked, but now I have one problem. I need to count the number of tasks that are labeled as "1" and show it in a graph by Status, as it is not a collumn it's not working. Can you help with it?

Re: Combine filters, Filter exception,

Greg_Deckler — Thu, 26 Mar 2020 19:26:56 GMT

You should be able to do this:

Count Measure = VAR __Table = ADDCOLUMNS( 'Table', "__Selected",[Selected] ) RETURN COUNTROWS(FILTER(__Table,[__Selected] = 1))

Re: Combine filters, Filter exception,

Anonymous — Fri, 27 Mar 2020 00:18:41 GMT

Greg_Deckler ,

Thank you very much, It works!

But now I noticed one thing, I can't select more than one month, do you know how to solve this?

Is there a function to conver all values between MAX and MIN?

Re: Combine filters, Filter exception,

Greg_Deckler — Fri, 27 Mar 2020 02:04:17 GMT

That's because you are using SELECTEDVALUE. You would have to use VALUES to get the values and then maybe use IN. Can you post expected output from the example data?

Re: Combine filters, Filter exception,

Anonymous — Fri, 27 Mar 2020 12:27:35 GMT

Greg_Deckler ,

I want to select 1 or more months and have all tasks from them and the past "Delay" tasks.

For exemple, if selected March and April the output would be (K,A,D,E,F,G,H,I,J).

Year	MonthNo	Month	Status	Task
2019	12	December	Delay	K
2019	12	December	On track	L
2019	12	December	Done	M
2020	1	January	Delay	A
2020	1	January	On track	B
2020	1	January	Done	C
2020	3	March	Delay	D
2020	3	March	Done	E
2020	3	March	On track	F
2020	4	April	Delay	H
2020	4	April	Done	I
2020	4	April	On track	J

I realized that the year is not being considered, if I select january, december would not be shown. I could use 2001 (January 2020) and 1912 (December) but it would no be user friendly, is there a way to transforme numbers (MonthNo) in text just to show in the slicer?

Thank you!