Forum Discussion

CMoppet's avatar
CMoppet
Icon for Helper IV rankHelper IV
2 years ago
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...
Need Help
  • newellaa's avatar
    newellaa
    2 years ago

    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.

Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

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