Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Couldn't Load Visual Error - Measure with DISTINCTCOUNT

Hello,

 

I am having trouble getting a visual to display using a measure where I try to distinct count on a column and use multiple filters within the measure. Changing it to just count works, but this will duplicate some of the records in the count. This is the measure:

 
Stabilized Asset Count with Work Orders = CALCULATE(COUNT(WorkOrders'[Unit Search Tag]),'Query - Occupancy (New)'[Stabilized Assets]=1,'WorkOrders'[Estimated Cost]>0,'WorkOrders'[Approved]="Yes",'WorkOrders'[Status]="Closed",ISBLANK(OwnedProperties'[Disposition Date]),'OwnedProperties'[Activity]<> "Pending Dispo",NOT(ISBLANK('OwnedProperties'[Stabilization Date])),OR(WorkOrders'[Type] IN {"Inspections","Turnover"},AND('WorkOrders'[Type]="Service Request",'WorkOrders'[Maintenance Category]="True")))
 
The field Estimated Cost can have multiple rows for each Unit Search Tag, so I want a distinct count of the Unit Search Tags as long as one of the rows has an Estimated Cost greater than 0.
 
The error I get is: "Couldn't Load Visual: OLE DB or ODBC error: DM_GWPipeline_Gateway_UncompressedDataSizeForPacketExceededError"
 
 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Your solutions is great AnalyticPulse 

    Hi, Anonymous 

    Your entire error indicates that the uncompressed data of the current packet exceeds the size limit. As mentioned by AnalyticPulse, if you have a large dataset, then it can cause the current error. In addition, this error involves the gateway, you can also check the following to make sure that the gateway is installed in the recommended computer environment:

    On-premises data gateway sizing - Power BI | Microsoft Learn

    You can try taking a small portion of your dataset for testing. Use the DISTINCTCOUNT function in this small part of the data to determine whether the current problem is related to the size of the dataset.

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.