Sum Measure

Question

Hello,&nbsp;I have a measure that is supposed to be taking a sum of the fees associated for each product on each given day, but instead it is taking a plain sum of everything. My table looks something similar to this:&nbsp;&nbsp; &nbsp; &nbsp;Product&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Date&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;User&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Fee&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Product A&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;1/1/2023&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;1a2b&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;$2&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Product A&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;1/1/2023&nbsp; &nbsp; &nbsp;2b3c&nbsp; &nbsp; &nbsp;$2&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Product B&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;1/2/2023&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;5n2m&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;$2&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;Product B&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;1/2/2023&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;8s5v&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;$2&nbsp; &nbsp; &nbsp;&nbsp;The current issue that I am having is that when I create a measure to sum the fees, it is simply summing all of the values in my fees column, so in my example table above my sum would say $8, but the fee is only applied once per product per date, so the sum should say $4. I am just having trouble creating a measure that will sum the fees, but only once per product and per day.&nbsp;&nbsp;Any help would be greatly appreciated, thank you in advance!

jihwan_kim · Accepted Answer

Hi,
I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.
It is for creating a measure.
&nbsp;

&nbsp;
&nbsp;
Expected result measure: =
SUMX ( SUMMARIZE ( Data, Data[Product], Data[Date], Data[Fee] ), Data[Fee] )

&nbsp;

Forum Discussion

Sum Measure

1 Reply

Related content

Measure to sum MTD for ALL months

Rolling SUM / Cumulative SUM for measure

Summing a measure

Running sum

Average of Sum Measure

Product	Date	User	Fee
Product A	1/1/2023	1a2b	$2
Product A	1/1/2023	2b3c	$2
Product B	1/2/2023	5n2m	$2
Product B	1/2/2023	8s5v	$2