Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Counting Confusion

I created a table to show records that have a count of 2 or more:   But when looking at my tables from the editor, I see these records only once:   What on my table could be causing...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • dramus's avatar
    dramus
    8 years ago

    I can see it returning more than one, based on how the count was created. E.g. if you took the service out, it could produce more than one row. 

     

    Try creating a table with all the columns in it (cs.co,cs.service, cs.servicelevel,cs.startdate,cs.endDate,einfo.id,empstatus), my guess is you have two different SeviceLevels, einfo.id or empStatus, or something.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

dramus It only returns one row when doing that. I guess I have nothing to worry about then? Even when checking my SQL database I'm only getting one result for that record and type. Just confused on how PBI would be seeing 2...

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
8 years ago

I can see it returning more than one, based on how the count was created. E.g. if you took the service out, it could produce more than one row. 

 

Try creating a table with all the columns in it (cs.co,cs.service, cs.servicelevel,cs.startdate,cs.endDate,einfo.id,empstatus), my guess is you have two different SeviceLevels, einfo.id or empStatus, or something.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    dramus That was exactly it. The record was in 2 different company sets which I was unaware of. Thank you for your help!