Forum Discussion

YevD's avatar
YevD
Helper I
4 years ago
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...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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 _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.