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.
Dear All,
I have a simple table, which contains a measure showing the difference between prices of latest month and previous month (measure called 'Delta previous price'. See below simplified example:
How can I make a total sum of the measure 'Delta previous price'? A simple SUM or SUMX does not work.
Thanks for providing any suggestion.
Solved! Go to Solution.
Hi !
@Power_BI_Adapt
Use this Measure
Hi , @Power_BI_Adapt
According to your description, you want to calculate the sum of a measure .
If this , you can refer to :
(1)This is my test data:
(2)We can just create a measure like this:
Measure = SUMX( VALUES('Table'[Date]) ,[My Measure])
(3)Then we can meet your need:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Power_BI_Adapt
According to your description, you want to calculate the sum of a measure .
If this , you can refer to :
(1)This is my test data:
(2)We can just create a measure like this:
Measure = SUMX( VALUES('Table'[Date]) ,[My Measure])
(3)Then we can meet your need:
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This worked perfectly for me, thank you!
Perfect! This works!
Hi,
If you are looking for have a correct sum of the difference value, try to create the calculated column instead of the measure. it will be calculate the correct sum :
See below image that I create the new column :
Appreciate your Kudos and please mark it as a solution if it helps you.
Hi,
If you only want to display the total account in the table, you can activate the total option in the table format. If you are going to use this value in other calculations, you can create the Running total formula with "New quick measure".
I created a demo for you, hope it helps 🙂
Hi !
@Power_BI_Adapt
Use this Measure
Thanks for your suggestion. How can I make this without the Date table? Looking for a solution of just make a sum on a measure.
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |