Forum Discussion

Vincem35's avatar
Vincem35
Helper I
5 years ago
Solved

Exclude a Filter in a Calculated Table

Dear Community,  I am working with a transaction table and would like to count the number of product categories a client purchase within a time frame. results below are correct  In the...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Vincem35,

    As mahoneypat said, you can use the 'edit interaction' panel to ignore the external filter effect to break the current visualization graph.

    Since current Dax formulas not able to extract multiple values from the slicer and filters who used the same data source table field. So if you want to keep the filter effect and ignore a specific filter, you can try to create a calculated table to duplicate the raw table field that you used on the filter. Then you can add conditions into the DAX expressions to compare with both two filter selections.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Vincem35,

As mahoneypat said, you can use the 'edit interaction' panel to ignore the external filter effect to break the current visualization graph.

Since current Dax formulas not able to extract multiple values from the slicer and filters who used the same data source table field. So if you want to keep the filter effect and ignore a specific filter, you can try to create a calculated table to duplicate the raw table field that you used on the filter. Then you can add conditions into the DAX expressions to compare with both two filter selections.

Regards,

Xiaoxin Sheng