Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Table showing values differently for count and do not summarize.

Hi All,

 

In the below Table  (Image 1 below), The baseline hours (last column) are incorrect when i select dont summarize option, but they are showing correctly when I select count distinct (Image 2 below), but I want client names (2nd column, Image 1)) to be displayed. 

Client utilization %, billable hours and Basline hours are all Measures. Let me know any work around. 

Image 1

 

Image 2

 

 

1 Reply

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    can you share your model , are you joining 2 tables?  to me it looks like you might have a duplication happening.  Do you join tables together?  please share more information about how your data is modelled.  Screenshot from the layout screen showing the relationships.