Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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.
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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |