Forum Discussion
Solved
DistinctCount with filters
Hi, I'm trying to create a measure using distinctcount to calcualate the number of visits made by each user in each month. Here's what my table looks like: Table1 VisitID UserID VisitDat...
The above pbix has a simple measure and it works fine!
It was an issue with my relationships which I was able to resolve.
for anyone who's new to powerBI and faces this issue, remember that your active relationships work as filters for your data. Having a well modeled data model saves you a world of pain.
thanks again negi007 !