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

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?

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