Creating a DAX Risk Matrix in Power BI for Project Online

I’ve updated the original Risk Matrix for Power BI. Now it uses DAX formulas which makes it much faster. As well as solving the background image issue the previous version had.
👉 Watch next - Exploring the Synoptic Panel in Power BI, and building a Risk Matrix    • Exploring the Synoptic Panel in Power...  

00:00 intro
02:30 Performance analyzer in Power BI
07:00 DAX formula for active risks
08:40 new columns in the risk table
11:40 adding 2 “dummy” tables and aligning them in the model
16:05 building the risk matrix and adding the impact levels
20:00 setting the conditional formatting

I’m using the CALCULATE and the SWITCH(TRUE()) formula’s in this video.

Keep in mind that content I show on the video's is mostly available to you if you subscribe to the newsletter: http://eepurl.com/dsm7dj