Forum Discussion

maibacherstr's avatar
maibacherstr
Icon for Helper III rankHelper III
4 years ago
Solved

Compare Count of String Between Two Tables Given a Status Column

Hello, I'm stuck on the following measure. I have two tables, each with a Status column, and need to compare the number of "Operational" rows for each value in the Type column (in this example Type =...
Need Help DAX
Need Help DAX measure
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi maibacherstr 

any relationship between the two tables? Any bridge table?

  • maibacherstr's avatar
    maibacherstr
    Icon for Helper III rankHelper III
    4 years ago

    Hi tamerj1 thanks for starting to think this over. There is no bridge table, but as mentioned the two tables are already related -- they use the Type columns as keys. 

    Since the tables come from two very different data sources, one being extremely limited for its columns, there is no ID column or other unique values available for building that relationship.

     

    Thanks again

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      maibacherstr 

      please try

      CALCULATE (

          COUNTROWS ( TableA ),

          TableA[Status] = "Operational" 

      )

      Same for TableB

      • maibacherstr's avatar
        maibacherstr
        Icon for Helper III rankHelper III
        4 years ago

        tamerj1 It seems like there are some gaps between this measure and being about to compare both counts, such that if there is a difference between the two, then the result of the measure enables a conditional format. What am I missing, please?