Sales matrix, product hierarchy on rows, months across columns, four measures. Two million rows in the fact table, which I thought was nothing. It takes 35 45 seconds every time a slicer changes. Other visuals on the…
Measure is . For most months it lines up with last year fine, but four or five months come back completely blank even though there are definitely sales rows in those months a year earlier. The date table is a query off…
I have a measure that flags high value customers and sums their orders. Each row in the table looks right, but the total at the bottom is much smaller than adding the visible rows myself. Nobody at work seems surprised…
Report pulls from a SharePoint folder of monthly CSVs plus a SQL view. Desktop refresh is instant. Scheduled refresh fails with a credentials error, and on the dataset settings page there is a third data source listed…
Inherited a report that is one flat 12 million row table with 60 columns, refreshing in about 25 minutes. I want to break it into a star, but that is a week of work and the business is happy with the numbers today.…