Couldn't Load Visual Error - Measure with DISTINCTCOUNT

[skoziana]

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"

[v-jianpeng-msft]

Your solutions is great @AnalyticPulse 

Hi, @skoziana 

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.

[AnalyticPulse]

@skoziana 

It looks  like  your data size is larger than the capacity of your current capacity , could you please confirm if you're dealing with very large dataset?

Learn Power BI free:

https://analyticpulse.blogspot.com

Learn Power BI

DAX Functions

Powerbi Visualisation