cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Frequent Visitor

## Measure that sums based on the values of certain columns

Hi,

Sorry if I put this at the wrong place, or something is unclear, I'm a newbie.

I also couldn't find a similar problem unfortunately.

Problem explanation:

I am trying to write a measure that will return the sum of certain values based on two columns.

Below you can see how the data is formatted. In this dataset there are two (but could later be more) unique references, I want to sum the cost of the highest recommendations (based on the number in that cell: "recommendation 3:"). So it would take just one value per reference to sum. In this case the measure should sum the 1000 and the 1500 since they respectively have the highest recommendation number of this dataset.

I tried adding a calculated column with just the recommendation number and then running the calculation with that. But I couldn't figure out how to make a measure that sum's based on these two conditions. (I did this within the power query by copying that column to create a new column and slicing it so i only keep the number). Unfortunately also with this I couldn't make it to work.

Curious if this is possible and how I could approach this best, I am looking forward to your feedback!

Thanks a lot in advance and let me know if something is unclear 😉

Some sample data to visualize it:

 Reference Recommendations cost 1404BC_20_ recommendation 1: lorem itsem 500 1404BC_20_ recommendation 2: lorem itsem 850 1404BC_20_ recommendation 3: lorem itsem 1000 6308EC_24_ recommendation 1: lorem itsem 400 6308EC_24_ recommendation 2: lorem itsem 900 6308EC_24_ recommendation 3: lorem itsem 1100 6308EC_24_ recommendation 4: lorem itsem 1500
1 ACCEPTED SOLUTION
Solution Specialist

sumx(values([Reference),calculate(max[cost)) = 1500+1000=2500

2 REPLIES 2
Frequent Visitor

That was easier than I expected. Thanks a lot!

Solution Specialist

sumx(values([Reference),calculate(max[cost)) = 1500+1000=2500

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors