• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ignore duplicates values and calculate total

E

ExcelSur

Member
Hello Gurus
I have a table in Postgresql database that has duplicate values and I want to calculate target_sales based on sales_id column. I am looking for a measure using DAX.

Desired Result should be

sales_idtarget_sales
10​
3,000,000​
11​
4,500,000​
7​
2,500,000​
8​
3,500,000​
9​
5,000,000​
6​
1,500,000​


Appreciate all your help.

Thanks
 

Attachments

  • Chandoo_PowerBI.xlsx
    11 KB · Views: 3
Last edited:
You must log in or register to reply here.
Back
Top