cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
David01 Visitor
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]),
     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.

 

 

Captureb.PNG

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

 

 

Capturec.PNG

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. 

1 REPLY 1
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

 

Regards,

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: | |