Forum Discussion
Solved
Returning All Rows From One Side Table of Relationship
Hello and thanks for giving this a look, I would love some help on how to create a table visual which would return all rows from the fact table regardless whether a related entry exsist in the l...
Hi YevD ,
According to your description, I download your sample, in the visual Values pane, select Don't summarize when expanding the Amount column. When you choose sum or average etc. it represents a calculated value not the column itself.
Get the expected result.
I attach the sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi amitchandak ,
Unfortunately I am unable to achieve the desired outcome with either of those suggestions. Really not sure how a matrix would work here. Would you be so kind and show how it can be done in the model I shared?