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 c...
General Comment
Need Help
Show and Tell
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.

      • Shamatix's avatar
        Shamatix
        Post Partisan
        9 years ago

        Well I am not to familiar with the synthax on how to do with with a TRUE / FALSE, because usually I use "SUM" but this aint really a SUM and it aint an integer either?