Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |