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 two tables:
Table ORG
id | name | org |
123 | a | x |
456 | b | y |
789 | c | z |
Table HOLDINGS
id | units | value |
123 | 50 | 500 |
789 | 20 | 200 |
I would like to output a table (or matrix):
id | name | org | units | value |
123 | a | x | 50 | 500 |
456 | b | y | 0 | 0 |
789 | c | z | 20 | 200 |
The trick of course is to get the id 456 from the ORG table to show even with no values in the holdings table.
I've tried a calculated column of SUM(value) + 0 but it is still not showing.
I hope that is clear, any help is appreciated.
Solved! Go to Solution.
Hi @SiroPW ,
Create two measures:
Measure = IF(ISBLANK(MAX('Table (2)'[units])),0,MAX('Table (2)'[units]))
Measure 2 = IF(ISBLANK(MAX('Table (2)'[value])),0,MAX('Table (2)'[value]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @SiroPW ,
Create two measures:
Measure = IF(ISBLANK(MAX('Table (2)'[units])),0,MAX('Table (2)'[units]))
Measure 2 = IF(ISBLANK(MAX('Table (2)'[value])),0,MAX('Table (2)'[value]))
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try CALCULATE(SUM[Value]), ALL(Table[ID]), Values(Table[ID]))
Hi,
Using the Query Editor, merge the Holdings Table into the Org Table.
Hope this helps.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |