[URL] Worldwide Content Releastionship

Why isn't my Agg hitting when using DISTINCTCOUNT in Power BI???

EN Main Home

Constantly the latest news, events and article about Microsoft 365 and Azure.

HubSite 365 - The network about Microsoft 365 and Azure.

EN Main Events

EN Main Dashboard

EN Main Role Pro Office 365

EN Main Role Citizen Developer

EN Main Role Data Analytics

EN Main Role Azure Datacenter

EN Main My365

EN Main Content

EN Main Search

EN Main News

EN Main Know-How

#More-News

Power Query - Convert HTML to to **formatted** text in

Microsoft Loop app is finally here in Public Preview

Microsoft Loop: Everything You Need To Know

Azure Synapse Analytics - Introduction to Dedicated Pools

How to enable co-authoring for encrypted documents in Microsoft Purview #shorts

Search for SharePoint Using PnP Modern Search Web Parts

How to share a Microsoft Form via a QR Code

Color Theory for Report Designers and Data Analysts

Excel Shortcut To Unhide Columns Not Working

#Top-News

New Microsoft Loop app for modern co-creation

Microsoft Loop - think, plan and create together like never before!

NEW Windows 11 Snipping Tool and Clipboard History

Basic Form in Power Pages | EP 02

Scottish AI Summit

Microsoft Community Speakers

European Collaboration Summit 2023

Microsoft Build 2023

365 EduCon DC

EPPC European Power Platform Conference

Commsverse 2023

Events Slider Top 01

Breaking News 01

<h2>📣 Microsoft announces Copilot - All Videos and News</h2><p>Microsoft has recently announced a new AI technology for Microsoft 365 called Copilot. The technology is designed to help users of Microsoft 365 applications, such as Outlook, Teams, and SharePoint, to get more done faster and more efficiently.</p>

<div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;4,&quot;id&quot;&#58;&quot;865fd3e9-15c1-47c5-ad35-b85aff79c33a&quot;,&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;1,&quot;sectionFactor&quot;&#58;6,&quot;controlIndex&quot;&#58;1&#125;,&quot;addedFromPersistedData&quot;&#58;true&#125;"><div data-sp-rte=""><p><strong><a href="https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f" data-cke-saved-href="https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f" data-interception="on" title="https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f">Microsoft announces Copilot - All Videos and News ​​​​​​​</a></strong><br><br><a href="https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f" data-cke-saved-href="https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f" data-interception="on" title="https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f"><span class="fontSizeMediumPlus">Microsoft has recently announced a new AI technology for Microsoft 365 called Copilot. The technology is designed to help users of Microsoft 365 applications, such as Outlook, Teams, and SharePoint, to get more done faster and more efficiently.</span></a></p></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;position&quot;&#58;&#123;&quot;layoutIndex&quot;&#58;1,&quot;zoneIndex&quot;&#58;1,&quot;sectionIndex&quot;&#58;2,&quot;sectionFactor&quot;&#58;6,&quot;controlIndex&quot;&#58;1&#125;,&quot;controlType&quot;&#58;3,&quot;id&quot;&#58;&quot;cffdef26-531c-4508-ba1d-0ec4818b5dd0&quot;,&quot;webPartId&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;reservedHeight&quot;&#58;106,&quot;reservedWidth&quot;&#58;570,&quot;addedFromPersistedData&quot;&#58;true&#125;"><div data-sp-webpart="" data-sp-webpartdataversion="1.11" data-sp-webpartdata="&#123;&quot;id&quot;&#58;&quot;d1d91016-032f-456d-98a4-721247c305e8&quot;,&quot;instanceId&quot;&#58;&quot;cffdef26-531c-4508-ba1d-0ec4818b5dd0&quot;,&quot;title&quot;&#58;&quot;Image&quot;,&quot;description&quot;&#58;&quot;Add an image, picture or photo to your page including text overlays and ability to crop and resize images.&quot;,&quot;audiences&quot;&#58;[],&quot;serverProcessedContent&quot;&#58;&#123;&quot;htmlStrings&quot;&#58;&#123;&#125;,&quot;searchablePlainTexts&quot;&#58;&#123;&#125;,&quot;imageSources&quot;&#58;&#123;&quot;imageSource&quot;&#58;&quot;/sites/M365-CDN/SiteAssets/SitePages/Content-17177/2984954044-screen-2023-03-19-114620.jpg&quot;&#125;,&quot;links&quot;&#58;&#123;&quot;linkUrl&quot;&#58;&quot;https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f&quot;&#125;,&quot;customMetadata&quot;&#58;&#123;&quot;imageSource&quot;&#58;&#123;&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;c586972e-6975-4229-9d6a-3aa9bb613916&quot;,&quot;width&quot;&#58;200,&quot;height&quot;&#58;80&#125;&#125;&#125;,&quot;dataVersion&quot;&#58;&quot;1.11&quot;,&quot;properties&quot;&#58;&#123;&quot;imageSourceType&quot;&#58;2,&quot;captionText&quot;&#58;&quot;&quot;,&quot;altText&quot;&#58;&quot;Open the overview&quot;,&quot;overlayText&quot;&#58;&quot;&quot;,&quot;fileName&quot;&#58;&quot;screen-2023-03-19-114620.jpg&quot;,&quot;siteId&quot;&#58;&quot;40ef054e-5ec7-4552-ac92-09bbd4faa5e1&quot;,&quot;webId&quot;&#58;&quot;35f81bac-1b1d-4f8c-a038-0302a1a6ae55&quot;,&quot;listId&quot;&#58;&quot;870ffa3e-eb32-4905-82ab-9e57adb99968&quot;,&quot;uniqueId&quot;&#58;&quot;c586972e-6975-4229-9d6a-3aa9bb613916&quot;,&quot;imgWidth&quot;&#58;200,&quot;imgHeight&quot;&#58;80,&quot;overlayTextStyles&quot;&#58;&#123;&quot;textColor&quot;&#58;&quot;light&quot;,&quot;isBold&quot;&#58;false,&quot;isItalic&quot;&#58;false,&quot;textBoxColor&quot;&#58;&quot;dark&quot;,&quot;textBoxOpacity&quot;&#58;0.54,&quot;overlayColor&quot;&#58;&quot;light&quot;,&quot;overlayTransparency&quot;&#58;0&#125;,&quot;alignment&quot;&#58;&quot;Center&quot;,&quot;fixAspectRatio&quot;&#58;false&#125;,&quot;containsDynamicDataSource&quot;&#58;false&#125;"><div data-sp-componentid="d1d91016-032f-456d-98a4-721247c305e8"></div><div data-sp-htmlproperties=""><img data-sp-prop-name="imageSource" src="/sites/M365-CDN/SiteAssets/SitePages/Content-17177/2984954044-screen-2023-03-19-114620.jpg" data-sp-cust-siteId="40ef054e-5ec7-4552-ac92-09bbd4faa5e1" data-sp-cust-webId="35f81bac-1b1d-4f8c-a038-0302a1a6ae55" data-sp-cust-listId="870ffa3e-eb32-4905-82ab-9e57adb99968" data-sp-cust-uniqueId="c586972e-6975-4229-9d6a-3aa9bb613916" data-sp-cust-width="200" data-sp-cust-height="80" /><a data-sp-prop-name="linkUrl" href="https&#58;//www.hubsite365.com/en-ww/citizen-developer?id=7292c4e9-3ac4-ed11-83ff-000d3aac68b4&amp;topic=c9bc8cdb-0fc4-ed11-83fe-002248840a7f"></a></div></div></div><div data-sp-canvascontrol="" data-sp-canvasdataversion="1.0" data-sp-controldata="&#123;&quot;controlType&quot;&#58;0,&quot;pageSettingsSlice&quot;&#58;&#123;&quot;isDefaultDescription&quot;&#58;true,&quot;isDefaultThumbnail&quot;&#58;true,&quot;globalRichTextStylingVersion&quot;&#58;0,&quot;rtePageSettings&quot;&#58;&#123;&quot;contentVersion&quot;&#58;4&#125;&#125;&#125;"></div></div>

Why isn't my Agg hitting when using DISTINCTCOUNT in Power BI???

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what...