Showing the Max of a value across an entire dataset
Hi there, I have a dataset that I bring into PowerBI which lists SITE CRAFT DATE COUNT the data goes out to 2025. Each week there is a list of 15 crafts for Sydney and for Vancouver and the count per craft... per the image below. SITE CRAFT DATE COUNT Sydney Animation 21/03/2022 29 Vancouver Animation 21/03/2022 15 Sydney Animation 28/03/2022 37 Vancouver Animation 28/03/2022 9 Sydney FX 20/06/2022 28 Vancouver FX 20/06/2022 12 Sydney FX 11/07/2022 19 Vancouver FX 11/07/2022 22 What I am trying to do is show the max per craft and the week that occurs. So there would be two lines for each craft showing the name of the craft, the location, the week and that weeks count as it is the max across the entire data set. For example the output would look like; SITE CRAFT DATE COUNT Sydney Animation 28/03/2022 37 Vancouver Animation 21/03/2022 15 Sydney FX 20/06/2022 28 Vancouver FX 11/07/2022 22 So on and so forth. I tried to build a measure that was Calculate(SUM(CrewPlanCondensed[Count])) but then not sure how to use that measure in a table to display the other data (basically I made a mess of it). Would love some guidance on how to achieve this.