cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Creating measure using several aggregating values

Hello everyone,

I'ms struggling in building 3 different measure in Dax Syntax. In fact, I would like to calculate a measure based on the volume into a row divide by the sum of volume of several rows. Here is my usecase :

I have a table of country, brand, volumes and price such as below :

I would like to calculate 3 differents measures.

The first one is the proportion (in volume) of each brand into a specific country.

The second one is the difference of price (at a row level) with the average price at a country level.

The third one is the profit by row divided by the total volume of the country.

Here is the expected table in output :

1 ACCEPTED SOLUTION

Accepted Solutions
Super User II

## Re: Creating measure using several aggregating values

First := DIVIDE(SUM(Test[Volume]),CALCULATE(SUM(Test[Volume]),ALLEXCEPT(Test,Test[Country])),0)

Second = SUM(Test[Price])-CALCULATE(AVERAGE(Test[Price]),ALLEXCEPT(Test,Test[Country]))
Third = DIVIDE(SUMX(Test,Test[Volume]*Test[Price]),CALCULATE(SUM(Test[Volume]),ALLEXCEPT(Test,Test[Country])),0)

Proud to be a Super User!

3 REPLIES 3
Super User II

## Re: Creating measure using several aggregating values

First := DIVIDE(SUM(Test[Volume]),CALCULATE(SUM(Test[Volume]),ALLEXCEPT(Test,Test[Country])),0)

Second = SUM(Test[Price])-CALCULATE(AVERAGE(Test[Price]),ALLEXCEPT(Test,Test[Country]))
Third = DIVIDE(SUMX(Test,Test[Volume]*Test[Price]),CALCULATE(SUM(Test[Volume]),ALLEXCEPT(Test,Test[Country])),0)

Proud to be a Super User!

Frequent Visitor

## Re: Creating measure using several aggregating values

Thank you very much @vimal_parmar, I will test the measure and let you know about the results.

Frequent Visitor

## Re: Creating measure using several aggregating values

It works perfectly !!! Thank you very much @vimal_parmar to make it so easy !

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors