CountRows where column A contains a string and column B = a string.
I have been driving myself crazy with this, and I've looked around and asked colleagues and I can't seem to get there. I am used to Power Apps syntax, but not DAX so I really need some help. I have a table with many columns, two of which are important for a measure I am trying to create: Table = Project Overview Column 1 = Project Name Column 2 = CP I need to get the number of rows where: Project Name contains "Mission" AND CP = "Missing CP" I got this far: calculate( COUNT( 'Project Overview'[Project Name] ), CONTAINSSTRING('Project Overview'[Project Name],"Mission")) But I can't figure out how to add a second condition in my filter. Can anyone help?
Sales orders that contain apples Y/N
Hi, What is the column or measure formula to generate the Y or N in the 'Does the order contain apples' column? Using a DirectQuery model. OrderID Item Does the order contain apples? 001 Apples Y 001 Brocolli Y 002 Pears Y 002 Apples Y 002 Bananas Y 003 Bananas N 003 Pears N 004 Apples Y Thanks for your help.
CONFUSED WITH USING CONTAINS, CONTAINSSTRING NEED HELP!
Hi guys, all I want to do is simply count all sales orders that contains at least 1 of the products for a selected order. My forumla is shown below. Essentially just confused on how to use contains or containsstring to essentially search for shared values. Any help would be appreciated !FIND ORDERS WITH SAME PRODUCTS
Hi guys, I want to create a simple measure that would simply count all the orders that share at least 1 of the same products of a selected order. For example. When I choose ORDER 2 which contains PRODUCT A (PA) , PRODUCT B (PB) I want it to be able to count the orders highlighted in green (shown below) This is my calculation but I cannot get it to work. Any help would be appreciated.Using Switch and Contains for Multiple Conditions
Hello, I have a dataset with two specific columns, Marketing_grouping and campaign_name. I want to create a new column that reads the text string in the campaign_name column and returns a value. We want to identify if the campaign is a Brand or NonBrand campaign. There are other campaigns that are not Brand or Nonbrand specific, so if possible, the new column would return the Marketing grouping. Essentially we are splitting the Marketing_Grouping, Paid Search, into 2 groups, brand and nonbrand, and using the campaign name column to identify. Also, there are paid search campaigns that do no have brand or nonbrand in Its name and we will group them under nonbrand ** Case sensitive: If campaign_name contains NB, Non, non, Non-Brand, and Marketing group = Paid Search, then NB If Campaign_Name contains Brand, BR, and marketing group = Paid Search, then Brand If Marketing_group = Paid Search and Campaign name doesn't contain any of the above, then NB Else, Marketing_Group (all other non paid search campaigns, use marketing group)
