Forum Discussion

Mking4646's avatar
Mking4646
Frequent Visitor
3 years ago

GrandTotal Issue

I'm assign Staff roles to customers based on customers spend, I have created a measure that assigned the roles and created individual role measures in order to show the revenue generated.   My issu...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Helpo Mking4646 

Please try

 

Correct Total = IF(HASONEFILTER(table[Custom 1]),[Your Measure],SUMX(VALUES(table[Custom 1),[Your Measure]))
Mking4646's avatar
Mking4646
Frequent Visitor
3 years ago

Unfortunately it's numbers are off with the original numbers

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hmm try to change the column name in the formula i gave you like use 

    Correct Total = IF(HASONEFILTER(table[sub region]),[Your Measure]

     

    • Mking4646's avatar
      Mking4646
      Frequent Visitor
      3 years ago

      Unfortuantely I thought it worked but the grand totals don't match the sum of the column