Distinct Count in Aggregation table (Huge data table)

[Santhoshyeravel]

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

[Santhoshyeravel]

hi @Anonymous 

thanks for the reply 

Able 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 ?

[Anonymous]

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.

[Anonymous]

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

Count of Unique Values (DistinctCount) in Power BI Through Power Query Group By Transformation - RAD...

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.