Tricky One - SOS!

[Anonymous]

I have "Yes" in different columns [indicating if a service is given to a customer or not]. A row indicates entry of one customer [there can be multiple line items for one customer]. And have Revenue in yet another column. I want to add up all revenue generated only from any 1 type of service [e.g. in data below - if I select a Yes in Reporting, revenue total should be 40,000 and not 50,000]

Account Name   ContractNumber   Revenue    Modeling   DataClean   Reporting

         A                        12345             40,000           Y                                   Y

         A                        23682             10,000                               Y               Y

         B                        46782              25,000          Y                  Y              

[v-eqin-msft]

Hi @Anonymous ,

Any updates? Sorry for that the information you have provided is not making the problem clear to me. 

As @HotChilli mentioned, we need to know the logic of  this: if I select a Yes in Reporting, revenue total should be 40,000 and not 50,000]

You may refer to the blogs below to know how to share more details to help us clarify your scenario.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[HotChilli]

What is the logic behind this?  For example, why is it 40000, not 10000?