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 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 :
Can someone help me about this stuff ?
Thank you in advance !
Solved! Go to Solution.
First := DIVIDE(SUM(Test[Volume]),CALCULATE(SUM(Test[Volume]),ALLEXCEPT(Test,Test[Country])),0)
First := DIVIDE(SUM(Test[Volume]),CALCULATE(SUM(Test[Volume]),ALLEXCEPT(Test,Test[Country])),0)
Thank you very much @Anonymous, I will test the measure and let you know about the results.
It works perfectly !!! Thank you very much @Anonymous to make it so easy !
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 |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |