Showing results for 
Search instead for 
Did you mean: 
David01 Visitor

Totals for a group filtered dataset

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


Capturea.PNGMy dax utilizing the grouping table

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

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. 

Community Support Team
Community Support Team

Re: Totals for a group filtered dataset

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



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |