-
One of the few golden rules in DAX is to always filter columns and never filter tables with CALCULATE. This article explains the rationale behind the rule. Read more
-
This article shows how you can highlight a single value in visual when comparing the distribution of a measure for one value versus all others. Read more
-
This article describes the DAX row context using a conceptual model based on a visual representation. Read more
-
I am proud to announce the second version of the Contoso Data Generator! In January 2022, we released the first version of an open-source project to create a sample relational database for semantic models in Power BI and Analysis Services.… Read more
-
Did you ever want to extract a VPAX file using a command line tool? If you are among the early adopters of DataOps principles or simply want to automate processes, you will be glad to know that we now have… Read more
-
This article clarifies how DAX evaluates variables, which is important to avoid common mistakes when using DAX for the first time. Read more
-
This article introduces the ‘atomic design methodology’ as an approach to make Power BI development more efficient and repeatable. Read more
-
We recently surpassed the 100,000 subscribers milestone on the SQLBI YouTube channel. Therefore, Alberto and I unboxed the plaque received by YouTube. We are still fighting for who should keep it! Thank you all for watching us. Read more
-
This article describes the DAX filter context using a conceptual model based on a visual representation. Read more
-
This article describes a simple approach that you can apply to improve your reports and dashboards. Read more