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
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?

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