Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Issue with distinct sum in direct query mode

Feedback Type: Frown (Error) Timestamp: 2020-05-08T05:59:20.1384575Z Local Time: 2020-05-08T11:29:20.1384575+05:30 Session ID: 46094eca-6fb1-4f23-a017-9c2abb4ba538 Release: January 2020 Product Version: 2.76.5678.1521 (19.12) (x64) OS Version: Microsoft Windows NT 6.3.9600.0 (x64 en-US) CLR Version: 4.6.1 or later [Release Number = 394271] Peak Virtual Memory: 35.1 GB Private Memory: 1.44 GB Peak Working Set: 1.53 GB IE Version: 11.0.9600.19678 User ID: 362e71b2-95f8-49c9-bbf3-ee067721a8dd Workbook Package Info: 1* - en-IN, Query Groups: 1, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Snapshot Trace Logs: C:\Users\spatil2\AppData\Local\Microsoft\Power BI Desktop SSRS\FrownSnapShot118313595.zip Model Default Mode: DirectQuery Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_NewWebTableInference PBI_showIncrementalRefreshPolicy PBI_qnaLiveConnect PQ_AIInsightsFunctionBrowser PBI_realTimeRefresh PBI_QueryDiagnostics PBI_showMinervaRibbon PBI_showMinervaViewNavigator PBI_decompositionTree PBI_themeDialog Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 125% Supported Services: Power BI Report Server, Power BI

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

Did you want to get sum values based on distinct values in another column? 

 

Please take a look at these similar threads: 

https://community.powerbi.com/t5/Desktop/Help-with-DAX-sum-of-distinct-values-grouped-by-another-column-s/td-p/651691

 

https://stackoverflow.com/questions/43547620/sum-distinct-values-for-first-occurance-in-power-bi

 

Best Regards,

Qiuyun Yu