Calculate sum without considering the duplicate values in another column

Hi Team, I have 3 columns (lead_id, stage_id and expected_revenue). I want to calculate the sum of expected_revenue for each stage_id, but the lead_id has a duplicate value. So I want to sum the exp...

Need Help

smpa01

4 years ago

powerbiss

Measure =
SUMX (
    SUMMARIZE ( 'Table', 'Table'[stage_id], 'Table'[expected_revenue] ),
    'Table'[expected_revenue]
)

parry2k
4 years ago
powerbiss add a new column using following DAX:

Status Columns = IF ( YourTable[Stage_Id] = 1 && YourTable[expected_revenue] = 0, "Open Leads", "New Opportunities" )

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

Forum Discussion

Calculate sum without considering the duplicate values in another column

Related content

Duplicate ranking

remove duplicate value within a row

Removing Duplicates

Bottom 10 considering repeated value.

Identifying duplicates