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.
I've created a mockup report that mimics my real data. I give this report to all Project Managers to view their workers Available monthly hours, project forecast hours, and the variance of the two. I want to be able to use a dax formul or the filters to show only the variance >= 80 at the total level which still keeping the data drill-downs.
Right now when I filter variance greater than or equal to 80, it only filters at the project level. I noticed when I take out 'Project' from the rows then the filter will work showing only those with variance >=80. However, the Project Managers would like to see the drill down on the same page rather than drilling through to other pages and I cannot seem to figure that out.
Any help is appreciated! Here's a quick screenshot of my mockup data.
Any ideas?
I've tried IF statements in a DAX measure, but either it doesn't work or it ends up working the same as the filter which is only filtering on the project level. As mentioned, I'd like to keep the drill-downs, but have the filter work only at the top level total.
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 |
---|---|
145 | |
87 | |
66 | |
51 | |
45 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |