COLUMNSTATISTICS is a useful but slow function. To make it calculate faster, consider calculating only the portion of it that is used in the DAX expression from which it is called. For example, if I use SELECTCOLUMNS(COLUMNSTATISTICS(),[Table Name]), then only the Table Name column should be calculated. If I use FILTER(COLUMNSTATISTICS(),[Table Name]="Table1"), then the statistics columns of COLUMNSTATISTICS should be calculated only for the columns of Table1. This is in contrast to calculating all of COLUMNSTATISTICS and then filtering the result to show only the rows for Table1.
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Support SNC Authentication for SAP BW in Power BI Report Server
Organizations are increasingly moving toward encrypted and certificate-based authentication for SAP BW connections due to security and compliance requirements. Currently, Power BI Report Server (PBI...Indramouli17 hours agoNew MemberNew4Views0likes0CommentsHow to remind the Global team to respond to ECNs with greater efficiency
Suggest Power BI send emails to each responsible person, and display how many days they have spent handling each ECN, compared to the required number of calendar days for completion.richardzhu1 day agoNew MemberNew36Views5likes2Comments