I feel like this is an easy fix but im abselutely stumped.....
I have seen a couple of forums for items similar to this but they were slightly different/specific and i wasnt sure how to work those methods into my situation.
I have created a couple of measures.
1. is to caclualte Points times Qty of items.
While these formula gave me proper results in the view i dont get a grand total for the view it just says 0
This is where i cant seem to figure out how to get Grand Totals. Please Help =]
Go to Solution.
Good Morning Everyone,
Thank you for your feedback and assistance on this one.
Just wanted to give a shout out to @tamerj1 .
I found an old post he was on and the solution below worked perfectly for what i was needing.
I was able to multiple 2 columns from different tables and get grand totals for my new field categories.
Thought i would share it in case it can help anyone else in the future. Thanks again!
VAR Name = Table1[Name]
VAR Value1 = Table1[Value]
VAR Value2 =
MAXX ( FILTER ( Table2, Table2[Name] = Name ), Table2[Value] )
Value1 * Value2
View solution in original post
@BobSled First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742eThis 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/63376Also, 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/547907Also: https://youtu.be/uXRriTN0cfYAnd: https://youtu.be/n4TYhF2ARe8
Please see this video. You'll need to use SUMX with VALUES or SUMMARIZE in your measure.
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.