Sum the Value of individual row value using DAX merasure

[VaishnaviP]

Hello Experts,

Date	Line	Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8
6/1/2024 0:00	A	0.33	0	165	0	8.047	1440	8	8
6/1/2024 0:00	B	0.08	0	390	0	2	1440	2	2
6/1/2024 0:00	C	0.17	0	405	0	3.229	1440	4	4
6/1/2024 0:00	D	0.15	0	180	0	2.806	1440	3.5	3.5
6/1/2024 0:00	E	0.56	0	285	0	13.97	1440	13.5	13.5
6/1/2024 0:00	F	0.52	0	225	0	12.2	1440	12.5	12.5
6/1/2024 0:00	G	0.56	0	1095	0	23.686	1440	13.5	13.5
6/1/2024 0:00	H	0.56	1065	0	0	12.55	1440	13.5	3.515625
6/1/2024 0:00	I	0.35	0	90	0	8.71	1440	8.5	8.5

This is a sample of my Data. Here I am calculating the values in Column 8 with the logic : ( (Column 6  - Column 2)/60) * Column 1.
With this, I am getting expected values in Column 8. Now in the Total, I want to get 69.01 as a value which is the sum of all rows in Column 8 but somehow not able to get this.

Any help on the solution will be deeply appreciated.

Thanks

[rajendraongole1 · Accepted solution]

Hi @VaishnaviP -  with above mentioned data,  able to get the value total 68.78. can you please cross check it?

Tested with one line "D" Column 8 we can achieve with 3.60 but in your data column 8 is show the wrong decimal.

 

The above is achievable with total as mentioned., please check and let know.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Ashish_Mathur]

Hi,

If column8 is a measure that you hae already written, then write this measure

Measure = sumx(values(Data[Line]),[Column8])

Hope this helps.

[Ritaf1983 · Accepted solution]

Hi @VaishnaviP 
The results of the calculation are not the same as in your image :

If this is the desired result you can use a formula like :

Column 8 Rita = Sumx('Table',(('Table'[Column 6]-'Table'[Column 2])/60)*'Table'[Column 1])

The Excel and PBIX is attached

if it is something else

please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test the coding formula.

How to Get Your Question Answered Quickly  

If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.

[rajendraongole1 · Accepted solution]

Hi @VaishnaviP -  with above mentioned data,  able to get the value total 68.78. can you please cross check it?

Tested with one line "D" Column 8 we can achieve with 3.60 but in your data column 8 is show the wrong decimal.

 

The above is achievable with total as mentioned., please check and let know.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!