Sum Measure

[NJ81858]

Hello,

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:

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

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. 

Any help would be greatly appreciated, thank you in advance!

[Jihwan_Kim · Accepted solution]

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.

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