Totals for a group filtered dataset

[David01]

I have created a filter using calculated buckets which works as I want except for the totals.(From much research - Im new to DAX)

My grouping table looks as per below

My dax utilizing the grouping table

Customer Recharge Groups = 
 
Calculate([Customer Recharge%],
   filter( values('Built'[NAME3]),
     countrows(
        filter('Customer Recharge Group',
            [Customer Recharge%] >= 'Customer Recharge Group'[Min]
            && [Customer Recharge%] < 'Customer Recharge Group'[Max]))
        >0))
        

The 'Built' table has many records for each customer 

the customer [Customer Recharge%] is a MEASURE calculation dividing 2 columns from the 'Built' table

This buckets the data as we want except for the total row when using the filter.

When we filter for say 0% the data set only shows values 0f 0% but the total in this instance shows 27%

Unfiltered (not using the 'grouping table'[group]) the total is correct

We are not applying any other filters other than the 'grouping table'[group]

If you can assist me in this I would be very grateful. 

[v-shex-msft]

HI @David01,

It seems like a common total issue, when you formula works on total level, its row content has summarize all records of current category. So your filter condition may triggered multiple groups and not return the correct result.

Please share some sample data to help us clarify your data structure so we can test and coding formula on it.

How to Get Your Question Answered Quickly

BTW, you can also take a look at following blog about measure total issues:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng