Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Removefilters issue

So I want to display a Matrix with Name, Year, a few categories and Cat. 2. (Additional page filters are applied)
Now for Cat. 2 rows I always want to display the Amount (Indem. GL) for Operational.
It works perfectly in a condensed form (less filters applied in the table) in _Test RC. Now putting all the filters in seems abit cumbersome so I tried doing the same with Removefilters.
However this does not work at all.

Can somebody explain why RemoveFilters does not work? And if there is another option insted of putting all Filters which should be kept in ALLEXCEPTED?

_Test RC = CALCULATE([_Indem. GL], FILTER(
        ALLEXCEPT(G_L_Entry, Q_Employee[Name],G_L_Entry[Year]),
        G_L_Entry[Cat. 2] = "Operational"
    )
)

_Test RC2 = CALCULATE( CALCULATE([_Indem. GL], G_L_Entry[Cat. 2] = "Operational"
    ), REMOVEFILTERS(G_L_Entry[Cat. 2]))
  • uzuntasgokberk's avatar
    uzuntasgokberk
    1 year ago
    Hello Anonymous,
    You can use your dax code like that:
    ... ,
    ALLSELECTED(G_L_Entry[Cat, 2])

    That makes return all values Cat, 2 but outside filters will be effected.

    İf you use ALL or REMOVEFILTERS instead of ALLSELECTED or ALLEXCEPT. That return all values and ignore everything.

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

     

5 Replies

  • uzuntasgokberk's avatar
    uzuntasgokberk
    Super User
    1 year ago

    Hello Anonymous,

    REMOVEFILTERS means also "ALL" and that means "Returns all the rows in a table, or all the values in a column, ignoring any filters that might have been applied. This function is useful for clearing filters and creating calculations on all the rows in a table."

    But ALLSELECTED means "

    Removes context filters from columns and rows in the current query, while retaining all other context filters or explicit filters.

    The ALLSELECTED function gets the context that represents all rows and columns in the query, while keeping explicit filters and contexts other than row and column filters. This function can be used to obtain visual totals in queries."

    İf you have slicers and if you would like your values to change when you make a slicer selection. you need to use ALLSELECTED. I have a blog on that if you are interested you can follow the link:  target=_blank target=_blank target=_blank target=_blankMastering Power BI DAX Functions: From Basics to Real-World Cases | by Gökberk Uzuntaş | Microsoft Power BI | Medium

    Kind Regards,
    Gökberk Uzuntaş

    📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

    🔗 Stay Connected:
    📘 Medium |
    📺 YouTube |
    💼 LinkedIn |
    📷 Instagram |
    🐦 X |
    👽 Reddit |
    🌐 Website |
    🎵 TikTok |

     
    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      ALLSELECTED removes all row and column context which is not what I want to happen, the figures should still be filtered based on year (cols) and name (rows), only the context of Cat. 2 should not be considered.

      • uzuntasgokberk's avatar
        uzuntasgokberk
        Super User
        1 year ago
        Hello Anonymous,
        You can use your dax code like that:
        ... ,
        ALLSELECTED(G_L_Entry[Cat, 2])

        That makes return all values Cat, 2 but outside filters will be effected.

        İf you use ALL or REMOVEFILTERS instead of ALLSELECTED or ALLEXCEPT. That return all values and ignore everything.

        Kind Regards,
        Gökberk Uzuntaş

        📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

        🔗 Stay Connected:
        📘 Medium |
        📺 YouTube |
        💼 LinkedIn |
        📷 Instagram |
        🐦 X |
        👽 Reddit |
        🌐 Website |
        🎵 TikTok |