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

 

 

What I would do is to create a measure for each of your conditions using the COUNTROWS

 

Approved = CALCULATE(COUNTROWS('Table1'), 'Table1'[ColumnName] = "True")

There might have to be some possible tweaking around the "True" but that should hopefully work, then that will give you the count of times it was Approved = True?

 

Shamatix's avatar
Shamatix
Post Partisan
9 years ago

I dont really want the count, what I want the result to be is end up with a slicer saying "Approved" "Failed" and if I press approved it will only show those rows where the value is "True" and if I pressed "Failed" it would show where its "False" 

  • 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.