This article describes techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. There are pros and cons to each technique. The article also includes performance considerations.
Read more

A typical example of ABC classification is the segmentation of products based on sales. The best-selling products that contribute to up to 70% of the total sales belong to cluster A. The products making up the next 20% of sales are in cluster B, whereas the products representing the last 10% of sales belong to cluster C.
Read more


Latest videos
Creating custom groups using calculation items
15:02#unpluggedAlberto Ferrari
Explaining wait time when you open a Power BI file
21:46#unpluggedMarco Russo
02:27#daxguideAlberto Ferrari
03:11#daxguideAlberto Ferrari
03:37#daxguideAlberto Ferrari
02:26#daxguideAlberto Ferrari


Latest news
• Advanced incremental refresh with the XMLA endpoint
It is unusual for us to include a Microsoft documentation update in our newsletter, but certain features seem too "technical" to deserve a separate announcement on the Power BI blog. Long story short: you can control incremental refresh policies in a way that is not possible from Power BI Desktop only, avoiding timeout errors in the first refresh and deciding which partitions to update. You need SSMS and/or Tabular Editor.
Jun 9, 2021 · Microsoft
• Improve Power Query performance in Power BI Desktop by optimizing evaluation containers
If you execute slow Power Query transformations in Power BI Desktop and are tired of waiting too much despite your computer being powerful, read these suggestions on how to optimize the evaluation containers used by the Power Query engine.
Jun 13, 2021 · Chris Webb
• Integrate Power BI deployment pipelines with Azure DevOps
Because of the API for the Power BI deployment pipelines, integration with Azure DevOps is not possible. The article is full of useful links to guide you in the application lifecycle management (ALM) world.
Jun 4, 2021 · Marc Lelijveld
• On-premises data gateway June 2021
Yes, you have to update your data gateway if you use it in Power BI - you know, a new release every month. No, there is no auto-update. Yes, we are looking forward to a better way to manage this. In the meantime, it is what it is.
Jun 9, 2021 · Microsoft