background filter replacement

[Anonymous]

Hi all,

We are creating a cost report for several different projects. We exclude older projects in a manual mapping (added column if project is still ongoing) and we have added this to the filter page in order to exclude these projects. Now the problem is that in case there are some backdated invoices/costs flowing to this project, we do not see it because of the background filter. 

Therefore I would like to create a way to include only projects in case there are YTD actuals or if there is an Latest LE assigned to it (instead of the background filter). In the below table it should exclude the yellow rows (no sum of LE or YTD actuals)

Regards

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Please try:

Flag = IF(ISBLANK(MAX('Table'[Sum of LE]))&&ISBLANK(MAX('Table'[YTD Actuals])),0,1)

Then apply it to the filter:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

anyone? 

Perhaps I was not fully clear in explaining this.

But basically I am looking for a way to exclude rows when there is a blank value in column YTD Actuals AND Sum of LE. 

Regards