March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
User | Count |
---|---|
122 | |
98 | |
89 | |
74 | |
67 |
User | Count |
---|---|
139 | |
115 | |
114 | |
98 | |
98 |