Forum Discussion
Distinct Count in Aggregation table (Huge data table)
Hi All,
I have table with huge data of records around 700 million used the aggregation table for some KPI which are using the sum aggregation functions but unable to get the distinct count with out hitting the table directly
due to hitting the table directly using the direct query mode some times the visual is getting time out error(255 secs).Can you please suggest how to get the distinct count aggragtion based on the user selection in the slicers
3 Replies
Hi Santhoshyeravel ,
I have found some similar posts, please refer to.
Solved: Calculate distict count based on slicer selection ... - Microsoft Power BI Community
Solved: Distinct Count & Group by based on slicer selectio... - Microsoft Power BI Community
How to Get Your Question Answered Quickly
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi Anonymous
thanks for the replyAble to get the distinct count but using the direct query it has taking more time and visual is getting time out error(255 sec) .Is any other way to slove this issue ?
Hi Santhoshyeravel ,
Please provide the screenshot with the error.
I have also found a helpful document, please refer to it to see if it helps you
Using DirectQuery in Power BI - Power BI | Microsoft Learn
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
