Forum Discussion
Conditional Column with Match and Specific Text Criteria
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.
Hi CMoppet
Try :
No. of Failures = Calculate (countrows('WO Raw Data'),'WO Raw Data' [MTBF Repair?]="Repair")
If it won't work:
please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello 🙂 My initial statement works fine to count the rows with 'Repair'...the bit I'm struggling with is how to only countrows where it says 'Repair' AND where the Month/Year and .MACHINE TYPE match too.
Here's what BASESUMMARY looks like...
So I want to add a column to this that counts how many rows in the 'WO Raw Data' table have the same MACHINE TYPE, the same MONTH/YEAR, and state 'Repair' in a column called 'MTBF Repair?'. For example, there may have been 25 'Repair' visits for KLIX OUTLOOK in JUNE 2024, so my new column should show 25 for this row.
I can't screenshot the 'WO Raw Data' table as I can't get everything in view. I appreciate your help