Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a 2 slicers - one for areas and one for regions. I need to a measure to show total sales for all areas and regions. I tried the below formula but the error message says I can't refer to more than one table within the REMOVEFILTERS function. Please can someone tell me how to resolve?
Solved! Go to Solution.
You can't refer to columns in different tables in REMOVEFILTERS or ALL. Make a separate REMOVEFILTERS for each column).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you both! 🙂
Use the ALL function instead, referencing the fact table you are calculating sales on. For example:
Measure = CALCULATE(SUM(Table[sales]), ALL(Table))
Proud to be a Super User!
Paul on Linkedin.
You can't refer to columns in different tables in REMOVEFILTERS or ALL. Make a separate REMOVEFILTERS for each column).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
171 | |
109 | |
109 | |
73 | |
71 |