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.
Hello there,
I'm having trouble calculating correct subtotals. I have a visual which is filtered by multiple slicers. I have struggled with this for hours and the best I achieved is that it calculates correct totals by region but whenever I choose a random amount of values to show it outputs the totals for the whole region. Furthermore, it should switch and calculate on the basis of field parameters which are country and project id. I'm attaching a screenshot of the setup.
Here's my formula:
Solved! Go to Solution.
Hi @Kate_Lashko ,
You can create a new measure and place it on the visual object.
NewTotalMeasure = SUMX(VALUES(Table[Country]), [Total])
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Kate_Lashko ,
You can create a new measure and place it on the visual object.
NewTotalMeasure = SUMX(VALUES(Table[Country]), [Total])
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |