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

Oh ok I would then do that in the Query Editor and create a conditional column based on if it is True or False.

 

Then use that new Conditional Column as your slicer in your data.

Shamatix's avatar
Shamatix
Post Partisan
9 years ago

Yes but I cant create a conditional column in Table B based on a column in Table A as far as I know (It only shows the column in the table you are creating the conditional column in)

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    That is correct, as far as I currently know that is a limitation in Power BI.


    What you could do after you create it in the one table, is in the Data Model you could create a Calculated Column there and as long as you have your relationships you could then use the RELATED function to bring it into your second table.

  • Shamatix's avatar
    Shamatix
    Post Partisan
    9 years ago

    Well with Related I can only go over to my "IKEY" table, as mentioned I have a many to many relationship so I needed a relationship table in order to create a relationship between the two.