Forum Discussion
Text Field Counted Twice
I have a fairly simple excel spreadsheet but it's pretty long. I'm trying to visually represent how many trips per day for manpower reasons, and it counts all instances twice, I can't figure out why....
don't know why what you get is counting twict.
i think you don't even need to create dax
pls see the attachment below
I could indeed just do a pivot table, but I'm asked to plop this into PBI, hence why I'm fighting with it. I'll just go ahead and re-import as a csv, I haen't tried that yet, maybe it'll remove whatever odd thing is causing PBI to count everything twice.
Thank you for looking at my question, I really appreciate it!