How to Display Multiple Rows in a Single Cell of a Matrix or a Table

How can I condense multiple rows into a single cell in a Matrix or a Table? https://youtu.be/bjCclP7aTCQ Obviously, it is easy to display all details like you see below: But what if for every product I just want to know what countries it is selling in and what channels are used? Like how it is … Continue reading How to Display Multiple Rows in a Single Cell of a Matrix or a Table

What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)

Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)

Taking another look at ALL() and ALLSELECTED() Functions

I have a video that takes another look at All() and AllSelected() functions. I start by talking about the flow of filters in the model. The direction of the arrow in the relationship between Fact and Dimension matters. With this background, I talk about using All() and AllSelected() function on Dimension table and compare it … Continue reading Taking another look at ALL() and ALLSELECTED() Functions

Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)

Price Volume Mix (PVM) calculation is one of the most popular topics on my blog and YouTube channel. Although, I have covered the DAX for the perfect PVM before, I have gotten a lot of requests to extend the PVM logic to include a separate bucket for discontinued products as well as new products. You … Continue reading Price Volume Mix (PVM) Calculation in Power BI with New and Discontinued Products (Power BI Dax Tutorial)