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?
DAX with double tables
Hello everyone, i have a MOM consumption data, I want to choose the month I want to analyse and the period "X" for which I want to compare ( last 30/60/90 days) "Y". All Dax works fine however if I want to get the value of only the new items for "X" compared to "Y", it compares it to the data in all the other months. I'm ready to clarify if needed. Thank you in advance.
Filter depends on different column value
Hi, what I am trying to do is to filter 'Inventory Material DC'[IMDC DC], based on 'Distributor'[DIST Country]. 'Distributor'[DIST Country] should be equal to "Poland" or "Denmark". 'Inventory Material DC'[IMDC DC] can be all if 'Distributor'[DIST Country] is not "Poland", if "Poland" then 'Inventory Material DC'[IMDC DC] should be different than 100. Is it possible to create such a filter? *I am using PowerBI Report Builder. DEFINE VAR yesterday = TODAY () - 1 VAR from_date = TODAY () - 28 MEASURE 'Inventory Measures'[Operational Inventory Total] = CALCULATE ( [Operational Inventory], FILTER ( ALL ( 'Inventory Date' ), 'Inventory Date'[INVD Date] >= from_date && 'Inventory Date'[INVD Date] <= yesterday ) ) EVALUATE SUMMARIZECOLUMNS ( 'Distributor'[DIST Country], 'Inventory Material DC'[IMDC DC], FILTER ( VALUES ( 'Distributor'[DIST Country] ), ( 'Distributor'[DIST Country] = "Poland" ) || ( 'Distributor'[DIST Country] = "Denmark" ) ), "Operational Inventory Total", 'Inventory Measures'[Operational Inventory Total], )
Sum in Matrix visual with filters from multiple tables
I will try to put my question out again as there were some issues with posting when I updated it. I am trying to sum data in a Matrix with filters from multiple tables and am unable to determine the correct measures to use. What I am looking is result similar to the below: I am unable to share the pbix, below is a view of the four separate tables of data I import into Power BI: The data structure and measures I have tried so far: 1) Count ECountry = Calculate(DistinctCOUNT(Sheet1[ECountry]),KEEPFILTERS(Sheet1)) 2) Epic Size = Calculate(Sum('Sheet1 (4)'[ESize]), KEEPFILTERS(Sheet1),('Sheet1 (4)')) 3) Epic Size Alloc = Divide([Epic Size],(SUMX(Sheet1,Sheet1[Count ECountry]))) Any help with calculations or guidance on data structure is much appreciated! MelodySpecific Date range for projects
Hello! I hop my explanation does this justice. I am doing a Cost Savings Projects analysis. It is a manufacturing plant, and we are changing aspects of the production to lower cost. For example, Project 101 may be changing a bag type and Project 102 may be changing labels. Each project starts a different day and runs for 52 weeks. so one project may be 3/1/2020-3/1/2021 and the other will be 6/2/2020-6/2/2020. What I need to be able to do is associate the Project ID with its product SAP and then have it only pull that project during the 52 weeks that the project is running, and anything outside of that specific range to be 0 or blank. But I have only been able to filter using the date filter, but i need it to filter specifically to the Project ID itself since they all have different savings goals and date ranges. Thank you !!!!
