Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
I am hoping there is someone out there who can figure out the missing DAX measure i need.
I have a really simple scenario.
Context:
What I currently have:
What is currently happening:
Requirements:
What i have tried:
Total Assigned FTE (No FILTER) = CALCULATE([Total Assigned FTE], ALL('Projects'))
It sounds simple, but I cannot get it to work.
Many thanks in advance
Solved! Go to Solution.
Are you using slicers or filters from the pane? I'm asking because of the behaviour of Auto-exist in DAX. If you are using filters from the pane, there's no way to escape from them.
Are you using slicers or filters from the pane? I'm asking because of the behaviour of Auto-exist in DAX. If you are using filters from the pane, there's no way to escape from them.
Hi mlsx4, yes good question. I am using both page filters and also the selected values on the report page itself (the values within the tables).
I appreciate your time and input.
I will have to test another method which requires referencing a table and creating a measure which uses the values in the referenced table. So it should be disconnected from everything and no filters will affect it whatsoever. Hope it works!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
83 | |
65 | |
52 | |
49 |
User | Count |
---|---|
211 | |
87 | |
80 | |
69 | |
60 |