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.
Hello,
Please can you help me in adding target to the matrix. I tried to add a measure as Target =2 and it works for individual records but it does not sum and in the total it shows as 2 rather than summarized. Not sure how else to add this target.
My raw data as
TM | RD | OrdID | OrdStatus | OrdStatusDate | Region |
John Smith | Steve Tanner | ABC123 | Entered | 1/1/2022 | West |
John Smith | Steve Tanner | ABC123 | Shipped | 1/5/2022 | West |
John Smith | Steve Tanner | ABC123 | Complete | 2/10/2022 | West |
John Smith | Steve Tanner | ABC234 | Entered | 1/1/2022 | West |
John Smith | Steve Tanner | ABC234 | Shipped | 1/10/2022 | West |
John Smith | Steve Tanner | ABC234 | Complete | 1/15/2022 | West |
John Smith | Steve Tanner | ABC345 | Entered | 2/5/2022 | NW |
John Smith | Steve Tanner | ABC345 | Shipped | 2/7/2022 | NW |
John Smith | Steve Tanner | ABC345 | Complete | 2/10/2022 | NW |
Mary Jane | Bridget F | DEF123 | Entered | 2/5/2022 | East |
Mary Jane | Bridget F | DEF123 | Shipped | 2/5/2022 | East |
Mary Jane | Bridget F | DEF123 | Complete | 2/5/2022 | East |
Brad Marley | John Q | EFG123 | Entered | 2/16/2022 | East |
Brad Marley | John Q | EFG123 | Entered | 2/16/2022 | East |
Brad Marley | John Q | EFG123 | Entered | 2/16/2022 | East |
Brad Marley | John Q | EFG234 | Entered | 2/16/2022 | West |
Brad Marley | John Q | EFG234 | Entered | 2/16/2022 | West |
Brad Marley | John Q | EFG234 | Entered | 2/16/2022 | West |
Expected to have two outputs. When adding region, though John Smith shows up twice, he still has a target of 2 per region and when region is not displayed, he is still supposed to have 2 as the target. And the totals should sum up correctly.
Output 1:
TM | Region | Complete Count | Complete Target | |
John Smith | West | 2 | 2 | |
Mary Jane | East | 1 | 2 | |
John Smith | NW | 1 | 2 | |
Brad Marley | East | 1 | 2 | |
Brad Marley | West | 1 | 2 | |
Total | 6 | 10 |
Output 2:
TM | Complete Count | Complete Target | |
John Smith | 3 | 2 | |
Mary Jane | 1 | 2 | |
Brad Marley | 2 | 2 | |
Total | 6 | 6 |
Solved! Go to Solution.
Hi, maybe I misunderstand you, please try this one
complete_target =
var target = 2
return SUMX(SUMMARIZE(datatable,TM column),target)
Hi, maybe I misunderstand you, please try this one
complete_target =
var target = 2
return SUMX(SUMMARIZE(datatable,TM column),target)
Hi,
try this one
measure
complete_target =
var target = 2
return SUMX(datatable,target)
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |