Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
9 years ago

Measure Cross tables

Hey fellow power bi users,

 

 

I currently have 2 tables, table A and table B, table A has a column with TRUE and FALSE values, in table B i want to create a measure that points towards table As column saying something like (If TableA.Column = true, "Approved","Failed") so basicly a column that writes Approved every time Table As column return True and "Failed" everytime it Table As column returns "False" but I want this measure to be in Table B, how do I obtain this result?

Best regards

General Comment
Need Help
Show and Tell

11 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi Shamatix

     

    Do you perhaps have an example?

     

    From your description it appears that all the data and measure is happening in Table A?

     

    What is the relationship between the tables? 

    • Shamatix's avatar
      Shamatix
      Post Partisan
      9 years ago

      It's a many to many relationship so I have created a relationship column between em called "IKEY", all my other columns are in table B and I would prefer if I also could have the measure in table B instead of A:P

      • GilbertQ's avatar
        GilbertQ
        Super User
        9 years ago

        What happens if you try and create the measure?

         

        Measures can be created in any table if there are relationships between the data, so that should not be an issue. As long as the measure is bringing back the right results.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Shamatix,

    Firstly, merge the two tables in Query Editor.


    Secondly, expand the true/false column in the merged table.


    Thirdly, create a calculated columns using DAX below.
    Column = IF(Merge2[A.True/false]=TRUE(),"Approved","Failed")


    Regards,
    Lydia