Forum Discussion
Solved
Conditional Column with Match and Specific Text Criteria
I have two tables of data; 'BaseSummary' and 'WO Raw Data'. The first table is a list of all our different machines types and a count of how many we have of each. The second table contains technici...
Do you have a join defined between the two columns in the model view? It seems a concatenation of Machine Type and Month/Year columns is necessary in each table in order to join the tables on the new concatentated field.
I've solved this now, using the idea above to concatenate:
No. of Failures = COUNTROWS(FILTER('WO Raw Data',[MonthYearMachineType]=BaseSummary[MonthYearMachineType] && 'WO Raw Data'[MTBF Repair?]="Repair" ))