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.
Hi guys,
I am new here and I need a little help.
ID | Multiplier | Measure 2 | Measure 3 |
163884 | 1 | ||
163958 | 2 | 1 | 2 |
163962 | 2 | 1 | 2 |
164023 | 2 | 1 | 2 |
164024 | 1 | ||
Total | 7 | 4 | 28 |
The DAX code of measure 3 is (Measure 3 = CALCULATE([Measure 2]*[Multiplier]))
But I needed that the measure 3 sum the total and don't multiply, the total should be 6 instead 28.
Do I make myself clear?
Thanks for the help
Solved! Go to Solution.
you need to use SUMX
https://docs.microsoft.com/en-us/dax/sumx-function-dax
possibly with SUMMARIZE to get sum per ID
This is'nt a pretty solution, but it will work. 🙂
Make an extra column (i have called it "Measure 2,5") before you makre colum "Measure 3"
Use this Dax Expression.
Measure 2,5 = IF(Table1[ID]="Total";0;Table1[Multiplier]*Table1[Measure 2])
This is to get alle the results you need except the total.
Then make the "Measure 3" column with the following Dax Expression.
Measure 3 = IF(Table1[ID]="Total";SUM(Table1[Measure 2,5]);Table1[Measure 2,5])
This should give you the wanted result.
Hope this will help.
@Anonymous
Try this formula
Measure 3 = SUMX( VALUES ( TABLE[ID] ), CALCULATE([Measure 2]*[Multiplier]) )
Thank you guys, you are amazing!
This is a great community that I am so proud to become a member.
@Anonymous
Try this formula
Measure 3 = SUMX( VALUES ( TABLE[ID] ), CALCULATE([Measure 2]*[Multiplier]) )
This is'nt a pretty solution, but it will work. 🙂
Make an extra column (i have called it "Measure 2,5") before you makre colum "Measure 3"
Use this Dax Expression.
Measure 2,5 = IF(Table1[ID]="Total";0;Table1[Multiplier]*Table1[Measure 2])
This is to get alle the results you need except the total.
Then make the "Measure 3" column with the following Dax Expression.
Measure 3 = IF(Table1[ID]="Total";SUM(Table1[Measure 2,5]);Table1[Measure 2,5])
This should give you the wanted result.
Hope this will help.
you need to use SUMX
https://docs.microsoft.com/en-us/dax/sumx-function-dax
possibly with SUMMARIZE to get sum per ID
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 |
---|---|
113 | |
97 | |
79 | |
73 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |