PowerBI Paginated Report wildly wrong

[Sjmiller]

I have a published dataset on powerbi, I connect that data source to my paginated report, when I am in the query editor I drag over the fields I want to bring it. I also set my parameters. For a test I did just this year since our fiscal just restarted this is just October. When I click run the query I can see my data is there and is correct, I counted to make sure. However, when I go into make a table and do a simple measure such as Count(custID) to just tell me how many rows there are (I do want to count duplicates because this is an appt log so I want to know how many total appts there are ) it is giving me a crazy different number for each of my staff, what should be less than a hundred, its giving me values in the thousands for each person (and not the same value) I cannot figure out what is going on! The sql query returns the correct results, in powerbi with my visuals, they return the right results when I use both implicit and explicit measures. SO I know the data is right, and again when I am in the query builder the data is correct. but when I try to do an expression it is wildly off.

Thoughts?

[amitchandak]

@Sjmiller , Based on what I got, once you create a dataset in the paginated report and you already used a measure of countdistinct , that set is a table and now you are doing sum or count on that column.

To get that add the ID to the paginated report dataset and create a count distinct calculation there

[Sjmiller]

I am not creating report in PowerBi derive for paginated reports I am doing in the report builder desktop program