Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aggregation without Sum

Hi All,   I was wondering if you can help my in this part. Im trying to aggregate some numbers without summing them. So for each cycle.Name i want to have each type of available numbers for it with...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    5 years ago

    Anonymous  the DAX I gave you should generate the new table you are looking for.  When you say "new table" you mean a new calucated table that is in your data model yes?

     

LeapSheep's avatar
LeapSheep
Regular Visitor
5 years ago

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?