Total Not Showing in Table

DAX DAX Calculations
6

Hello @ysherriff,

Here’s the explanation between the two measures -

In old measure, you had stated the condition as - “If date range is in between 0 and 548 then provide the results of RFP Amount or else 0”.

So what it actually did is, it provided you with the correct results at an individual line item level but at a grand total level since there was no presence of any context, it evaluated the results as 0. And that’s why, it didn’t provided the overall summation of results at a grand total level.

Similarly, you could have achieved the same results by creating a measure in order to fix the totals. Below is the measure provided for the reference -

Fix Totals = 
SUMX(
   ADDCOLUMNS(
      SUMMARIZE(
          Deal , 
          Deal[Yuhanna's Campaign Test] , 
          Deal[Deal Name] ) , 
      "@Totals" , 
      [$ HubSpot Campaign RFP] ) , 
   [@Totals] )

But what I did is, removed that IF statement since in this particular scenario, it was not required and substituted that same condition or logic inside the Filter function as an expression.

I’m providing few links below for the reference purposes where similar type of queries were raised in the past by the members on our forum and how the “IF()” function works when it’s context is misunderstood.

Hoping you find this helpful.

Thanks and Warm Regards,
Harsh

1 Like