Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
77 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |