Forum Discussion
Removefilters issue
- 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 |
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.
Super UserYou 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 |
That does work for the simple measure provided.
When putting it in a more nested stmt however, it does fail again..._Measures =VAR ttable = SUMMARIZE(G_L_Entry,G_L_Entry[G_L_Entry_Employee.Source No],G_L_Entry[Year],"Montant", [_Indem. GL],"Montant Op", CALCULATE([_Indem. GL], G_L_Entry[Cat. 2] = "Operational", ALLEXCEPT(G_L_Entry, G_L_Entry[AnneeBud],Q_Employee[Name], Q_Employee[Mat])))VAR Result = CALCULATE(COUNTX(FILTER(ttable,[Montant Op] <= 0),G_L_Entry[G_L_Entry_Employee.Source No]))RETURN Result
The allselected stmt wont provide the same result- uzuntasgokberk
Hello Anonymous,
İt is hard to say because ı don't know the relationship and some of the measure you used in your dax.
İf the below code doesn't work that would be good if you share dummy pbi file.
CALCULATE(
COUNTX(
FILTER(
SUMMARIZE(G_L_Entry,
G_L_Entry[G_L_Entry_Employee.Source No],
G_L_Entry[Year],
"Montant",
[_Indem. GL],
"Montant Op",
CALCULATE(
[_Indem. GL],
FILTER(ALLEXCEPT(G_L_Entry, G_L_Entry[AnneeBud],Q_Employee[Name], Q_Employee[Mat]), G_L_Entry[Cat. 2] = "Operational")
)
), [Montant Op] <= 0
),
G_L_Entry[G_L_Entry_Employee.Source No]
)
)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 |