Forum Discussion
MikeBresnan
5 years agoHelper I
Count function not working?
I'm having issues with a count function not working. I tried it as a measure, and as a function within the value, but my count is way off. The field i'm trying to count has all unique values, so as f...
MikeBresnan
5 years agoHelper I
OK, lets try this again: here is the link to the cropped version of the sample data
https://drive.google.com/file/d/15z5LWjmO3urWuTaCv5YwKDKY2xdDiEmk/view?usp=sharing
The pivot table in Sheet2 shows how the data should be calculating
and here's how it shows in Power BI
Thanks for all the help/patience!
- Anonymous5 years agoNot applicable
- MikeBresnan5 years agoHelper I
Yup! that's what i would expect to see. If i create the YTDTOTAL measure based on that created date field, it's what i get. When i use the date table it's linked to, the count gets thrown off.