How to Aggregate / De-Duplicate

[LeapSheep]

 

I am trying to create a dashboard that shows the value of the company by event attended but Power BI keeps summing the value by the number of both Invididual and Event. 

See this example:

I wanted to have a summary of the value we delivered to Company just by unique events they have attended and not adding up the value based on the number of attendees.

For Company A, I wanted to see the total value we delivered adding from Founder Fundamentals Group Workshop (250), March 21 One on One (250), and April 21 One on One (250), total of 750. Power BI is adding up two entries from March 21 One on One so total becomes 1000. 

Is there a way to de-duplicate this?

[v-yalanwu-msft · Accepted solution]

Hi @LeapSheep  , 

By your description, you could create a measure as follows:

Aggregate =

var _newtable=SUMMARIZE('Table',[Company],[Event],[Value])

return SUMX(_newtable,[Value])

The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.  

[Jihwan_Kim]

Hi, @LeapSheep 

Please correct me if I wrongly understood your question.

I assume you dragged a Value Column into the visualization.

Please try to create a measure like the below picture and drag the measure into the visualization.

The below measure simply sums up under the condition that the event is not A.

I hope you can try to write a new measure something like below.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM