Good afternoon,
I am attempting to identify mismatched data in Power BI. However, I am totally new to BI and am intimidated by DAX.
I have two tables:
Table 1 is a list of business IDs, and what item types they are allowed to interact with
Table 2 is a list of business IDs, and what items they have interacted with
They look like:
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
My end goal is to be able to filter out any rows where the interactions are valid. I only want to see the rows where a business has interacted with items they are not allowed to interact with.
Those two tables are created from 4 data sources:
List of Business IDs/Item Interactions
List of Unique Business IDs
List of Business IDs/Allowed Items
List of Unique Items
With relationships between:
Unique Items > List of Business IDs/Allowed Items & Unique Items > List of Business IDs/Item Interactions
Unique Business IDs>List of Business IDs/Item Interactions & List of Unique Business IDs>List of Business IDs/Allowed Items
Hoping there's an easy solution. Thanks for reading this far!
I am attempting to identify mismatched data in Power BI. However, I am totally new to BI and am intimidated by DAX.
I have two tables:
Table 1 is a list of business IDs, and what item types they are allowed to interact with
Table 2 is a list of business IDs, and what items they have interacted with
They look like:
Table 1
Business ID: | Allowable Interactions: |
1 | Car |
1 | Toy |
1 | TV |
1 | Sweater |
2 | Car |
2 | Toy |
3 | Car |
3 | Oil |
3 | Table |
3 | Awning |
3 | Sweater |
3 | Key |
3 | Corn |
4 | Oil |
4 | Sweater |
<tbody>
</tbody>
Table 2
Business ID: | Items interacted with: |
1 | Car |
1 | Car |
1 | Oil |
1 | TV |
1 | Car |
2 | Car |
2 | Toy |
2 | Toy |
3 | Car |
3 | Oil |
3 | Table |
3 | Table |
3 | Awning |
3 | Car |
3 | Oil |
4 | Oil |
4 | Sweater |
<tbody>
</tbody>
My end goal is to be able to filter out any rows where the interactions are valid. I only want to see the rows where a business has interacted with items they are not allowed to interact with.
Those two tables are created from 4 data sources:
List of Business IDs/Item Interactions
List of Unique Business IDs
List of Business IDs/Allowed Items
List of Unique Items
With relationships between:
Unique Items > List of Business IDs/Allowed Items & Unique Items > List of Business IDs/Item Interactions
Unique Business IDs>List of Business IDs/Item Interactions & List of Unique Business IDs>List of Business IDs/Allowed Items
Hoping there's an easy solution. Thanks for reading this far!