Create a summary (SUM or SUMX) with multiple filter conditions

[DavidSasse]

Hi,

I'm new to Power BI and trying to basically created a calculated column in Power BI to add up some payments based on specific filters, in Excel I would use the following to create the filter column:

=IF(IF(COUNT(SEARCH({"97356719"},AT2)),"Code","Non Code") = "Code", "Code",(IF(COUNT(SEARCH({"Customer1","Customer2","Customer3","Customer4","Customer5","Customer6"},M2)),"Fixed Price","Not Fixed Price")))

AT2 and M2 are the data columns

is there a way to layout the DAX code to test two different column of data and mutiple string matches in each?

[v-xicai]

Hi @DavidSasse ,

Could you please share your sample data or desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Amy

[DavidSasse]

Hi @v-xicai 

Sorry for my late reply.

https://computacenter-my.sharepoint.com/:u:/g/personal/dsasse_gb_computacenter_co_uk/EQmg6q88pDlBniT...

thanks

David

[DavidSasse]

Just wondering if anyone can help me

[HotChilli]

The link to your data has expired.  I suggest starting a new thread (with a link to your data) and try to explain better what you want.

For example, Here is the current data

xxxxx xxx

Here is what I want returned

yyy

and here is the logic to make that happen