Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I have an issue trying to get the sum of the values in a measure. In the below screenshot, I want to be able to get the sum of the values in the column Weighted MAE% (33.1% and not 37.8%). In the total line I only get the calculation result for the total level (51/135) and the weights of each row is not considered.
How do I create a measure or column where I can the summed total for the weighted calculation in each row? I need to be able to understand the MAE% on aggregated levels considering the weight for each row and it has to be dynamic so that if I change the slicer to exclude e.g. Region 1, then it recalculates with new weights for each row.
Hope someone an help...
Solved! Go to Solution.
Hi,
Thank you for your feedback.
Could you please share your sample pbix file's link here? (Onedrive, googledrive, dropbox, any other...)
And then I can look into it to come up with a more accurate solution.
Or, please try the below if it is realted to two columns....
MEASURE totalfix =
SUMX (
SUMMARIZE ( TableName, 'TableName'[Region], 'TableName'[DG] ),
[Weighted MAE%]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your datamodel looks like, but please try to write a new measure like below, and put the below measure into the visualization.
MEASURE totalfix =
SUMX ( VALUES ( 'TableName'[Region] ), [Weighted MAE%] )
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks for the suggestion @Jihwan_Kim . Unfortunately, it does not yield the right result when I use the filters to select and deselect certain region or DGs. Is there a wa to make it dependent on all filters?
Hi,
Thank you for your feedback.
Could you please share your sample pbix file's link here? (Onedrive, googledrive, dropbox, any other...)
And then I can look into it to come up with a more accurate solution.
Or, please try the below if it is realted to two columns....
MEASURE totalfix =
SUMX (
SUMMARIZE ( TableName, 'TableName'[Region], 'TableName'[DG] ),
[Weighted MAE%]
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thanks @Jihwan_Kim , the summarize did the job! And it also works on more than 2 columns in the actual data set 🙂
@KMadsen This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |