Education Data Modelling

A look at modelling data for Power BI in an education setting.

Field Parameters in Tabular Editor

UPDATED WITH EXTRA REQUIRED STEPS The May 2022 release of Power BI brought an exciting feature that greatly enables self service BI. I’d highly recommend watching Wyn Hopkins: Field Parameters in Power BI giving a brief introduction. My organisations main models however are deployed straight from Tabular Editor via the XMLA end point. Therefore to […]

SUMMARIZECOLUMNS and Filters

This blog post originated from a question in the Power BI Community forum. The final solution is very straight forward but my aim is to illustrate an underlying behaviour in Power BI with a simple example. The problem can be seen in this pbix file. We have a basic data model: With the following two […]