Forum Discussion
Helper IIALL filter not working on fact table ?
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.
Super Userdusdau you have to use ALL ( TableName ) not ALL ( Table[ColumnName] )
✨ 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.
Helper IIThanks, but that removes ALL filters, not just the Profit Bucket filter? So if I want to remove Profit Bucket filter but include a Fiscal Year filter I get this:
Here I would want to see the FY year total in each column, regardless of profit bucket....if that makes sense?
The end goal is to calculate the % each Profit Bucket is of the FY Total to see change over Time (Fiscal Year).