Implement Row Level Security In Your Power BI Models

Whenever I think of row level security I think scale. There’s probably no better feature in Power BI for organisations. Instead of having to develop ten different reports for every sale region or for each different sales department, you can just create one detailed Power BI model and use row level security to make sure

Continue reading

Develop Advanced Scenario Analysis Models Using DAX in Power BI

I really wanted to showcase here how incredible Power BI is as an analytical tool. You can achieve so much that you might never have thought possible. Developing scenario analysis logic within Power BI models is probably my favorite technique to use, mainly because it can be so valuable to the business. Rather than just

Continue reading

Calculating Percent Profit Margins Using DAX in Power BI

Working out your profit margins in Power BI with a basic data set can seem like it requires a few steps. Maybe you think you need to use calculated columns to get the result. Well, you certainly don’t need to do that – there is a much simpler way. Using measures, you can start with

Continue reading

Quick Measures Deep Dive – How To Use Them in Power BI Models

Quick measures in Power BI is a fantastic feature that can increase the speed of development immensely. Here, I review how you can start using them and I look at the many considerations of actually implementing them. Quick measures isn’t perfect but it’s being updated all the time. The Power BI team have made a

Continue reading