Matrix Filters, if not blank, but 2 different collumns (Eg. Actual = not blank, OR LY = not blank)

[Rygaard]

I have a matrix

customer	Actual this year	Budget this year
A	100
B		100
C

I want A and B to be shown but not C

Is there a way to filter this

Normaly i would set filter for

"Actual this year" = not blank     But that would filter out C and B

"Budget this eyar" = not blank    But that would Filter out A and C

there is no way as i see it to make a combined filter ?

[nandukrishnavs · Accepted solution]

@Rygaard 

Create a calculated column using DAX or Edit Query.

Below is the DAX 

required = IF(ISBLANK(MyTable[Actual this year])&&ISBLANK(MyTable[Budget this year]),"No","Yes")

Then apply filter.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[nandukrishnavs · Accepted solution]

@Rygaard 

Create a calculated column using DAX or Edit Query.

Below is the DAX 

required = IF(ISBLANK(MyTable[Actual this year])&&ISBLANK(MyTable[Budget this year]),"No","Yes")

Then apply filter.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[Rygaard · Accepted solution]

@nandukrishnavs  - yes that is what i have now .. or sort of... 

has activity = ABS(MyTable[Actual this year])+ABS(MyTable[Budget])+ABS(MyTable[actual,LY]+ABS(MyTable[Budget, LY]))

and then a filter on that show if greater than 1

[amitchandak]

Ideally, C should not have come. Check have you check this option. Uncheck if checked

[Rygaard]

The problem is not that C is showing.... the probleing is having A and B stay.... either of the 2 filters will remove C but either of them will also remove to much