Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I have 2 following unrelated tables
| Name | Value |
| Name 1 | 0 |
| Name 2 | 0 |
| Name 3 | 0 |
| Name 4 | 0 |
| Name 5 | 0 |
| Name 6 | 0 |
| Name 7 | 0 |
| Name 8 | 1 |
| Name 9 | 1 |
| Name 10 | 1 |
| Name 11 | 1 |
| Name 12 | 1 |
| Name 13 | 1 |
| Name 14 | 1 |
| Name 15 | 1 |
| Name 16 | 1 |
| Name 17 | 1 |
| Name 18 | 1 |
| Name 19 | 1 |
| Name 20 | 1 |
| Name (Exception) | Value (Exception) |
| Name 1 | 1 |
| Name 2 | 1 |
| Name 3 | 1 |
| Name 4 | 0 |
| Name 5 | 0 |
I need to create 4 cards :
From Table 1 :
| Conform = 1 | 13 |
| No Conform (Not 1) | 7 |
From table 2 :
| Exception Conform (Not 1) | 2 |
| Exception No conform (=1) | 3 |
With condition : Name = Name(Exception) ; Value = or ≠ Value (Exception)
Thank you in advance for your help.
Solved! Go to Solution.
I would like to find a solution without joining the tables.
ok, what have you tried and where are you stuck? What prevents you from joining the tables?
I would like to find a solution without joining the tables.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.