title: How to SUM DISTINCT Values in a column based on a unique date in another column of a Power BI table
body: <p>I have a table in Power BI, where I have two columns like Date and Daily Targets. Daily Targets are always same on the same date so I need a measure to only SUM 1 value for 1 date instead of calculating every row because these two columns contains duplicate values. Please see at attached screenshot for the data table. <a href="https://i.stack.imgur.com/bu0F1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bu0F1.png" alt="enter image description here"></a></p>
  
  <p>As you look into my data, there are two distinct dates and all I need is when I add this Daily Target Column in any visualization, instead of adding 11653+11653+11653 for 3rd Jan, it should only Sum 11653 for 3rd Jan. Please help me with it, I will be very grateful to you. </p>