Forum Discussion
dusdau
Helper II
Helper IIALL filter not working on fact table ?
Hi All, I am trying to use ALL to remove a column from filtering on my Sales fact table and it is not working. It works fine when I using ALL to remove filters from dimension tables. How can I ...
dusdau first it is the biggest design flaw, you should be using Dimension and fact, full stop. You can surely solve it with DAX but why complicate things, anyhow following will work
Measure = CALCULATE ( SUM ( Table[Amount] ), ALL ( Table ), VALUES ( Table[Fiscal Year] ) )✨ Follow us on LinkedIn and to our YouTube channel
Check my latest video on Filters and Sparklines https://youtu.be/wmwcX8HvNxc
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
