Calculated Column: Ignore filter

[MrDigital]

Hi to all,

I created a calculated column which gives me a status if a target is reached.
It basically compares the values in column "plan" with the one in the column "actual".

I use this column for conditional formatting in a table.

I have several visualizations on a page and in the report which I filter with report level filter.

The problem I face is that when I use the report level filter (on a Month) the calculated column also gets filtered to this month and the conditional formatting therefore only works for the selected month. I need it for every month, ignoring the filter value.

For measures I succesfully used ALL() to ignore filters, but for the calculated column it does not work.
Do you have any idea?

Thank you,
Jan

[v-lionel-msft]

Hi @MrDigital ,

Are your [plan] column and [actual] column from DAX formula?

Could you give all your DAX formulas that you created?

Could you give relevant visualization screenshots?

Best regards,
Lionel Chen

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

[MrDigital]

Hi, 

thank you all for your help.

Since the data and file is confidential, I cannot share it. 

And sadly I don't have time to create a small pbix file with the same problem. 

But eventually I was able to solve my problem by using slicers instead of page / report level filter.

I sync the slicers across all pages and with "Edit interactions" I was able to disable the filtering of some visualizations. 

That is not as sleek as page filters, but it works.

I just wish that these functionality would also work for page / report filter, not only for slicers.

Thanks for your help!

[danextian]

Hi @MrDigital ,

That is the expected behavior based on your description.  If you filter a visual by a column from the same or related table, only the rows related to the selected items will be visible  so if you select "Product A" from Product column and "June" and "July" from Month column have this, only those months will be visible. 

Could you please post a sample data and your expected result? 

[amitchandak]

Typically all work better when you have it on dimension side.  You can also explore edit interaction to aviod few filter