Forum Discussion
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...
Hmm try to change the column name in the formula i gave you like use
Correct Total = IF(HASONEFILTER(table[sub region]),[Your Measure]
Unfortuantely I thought it worked but the grand totals don't match the sum of the column