Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey guys,
I have 2 tables who have a relation on the columns ordernr and invoicenr
When there is a match, the visual is doing fine:
But as soon as there is no match for a given ordernr, the value in the row is going blank but the total is still there. How can I show the quantity (which must be 6 in both rows).
I hope u guys can help me out 🙂
Thanks!
Solved! Go to Solution.
Thanks for the suggestions guys, recreating the relationship between te tables in the model solved the solution for me.
Thanks for the suggestions guys, recreating the relationship between te tables in the model solved the solution for me.
Hi,
Not sure what you want but try this. Use the Query Editor to append both tables and then build your visual from the appended table.
maybe you can try this
Measure = if(ISBLANK(sum('Table'[QTY])),sum(Table1[QTY]),sum('Table'[Qty]))
Proud to be a Super User!
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |