Grouped data does not drill down correctly

[brendan_w]

I'm after using the group functionality to create 6 groups from a field called donor. When I create a table that has the donor (groups) as  a column header, my measures give the correct results. However when I create a table with the individual donor, the measures output are that of the overall group. e.g.

Group Table

Group  ; Kgs Received;

Group 1 ; 98 kgs

Individual Donor Table

Donor; Kgs delivered;

Donor 1 ; 98 kgs

Donor 2 ; 98 kgs

Donor 3 ; 98 kgs

when they should be

Individual Donor Table (corrected)

Donor; Kgs delivered;

Donor 1 ; 10kgs

Donor 2 ; 30kgs

Donor 3 ; 58kgs

DAX measure is

Tonne Food Received = CALCULATE(sum('Monthly Data'[Total Kilos])/1000, NOT(ISBLANK('Monthly Data'[donor])),'Monthly Data'[Transaction Type] = "Received")

I'd expect the DAX expression to only evaluate for the rows where donor = donor1 etc. If anyone could point me in the right direction, it would be very much appreciated!

Many thanks,

Brendan

[Anonymous]

Hi @brendan_w,

Please help to post sample data of 'Monthly Data' table for us to analyze, also we need to know that how you create the Group table and what field you use to create relationship between 'Monthly Data' table and Group table.

Thanks,
Lydia Zhang