Hi, Is there a solution to deal with complex measure and Drill through details page, the report is slow as it recalculates the DAX measure by rows in details table on the drill through page. The measure drill through works but report performance is impacted which is not ideal for end users.
You likely need to optimize the DAX measure on the drillthrough page (assuming you can't further reduce the amount of detail on that page with additional filters, etc.). Please share the slow DAX expression to get optimization suggestions.
Pat
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
102 | |
77 | |
70 | |
48 | |
47 |
User | Count |
---|---|
158 | |
86 | |
80 | |
68 | |
66 |