Data Modeling

Power BI

Activating inactive relationships the smart way

Hi, today I want to talk about inactive relationships. Those relationships with the dashed line that unless you invoque them with USERELATIONSHIP they do nothing. The thing is a common pattern if you read this blog -- let's say you have a retail model, and for some charts you need to use the order d...
Leer post →
Power BI

Filtering the impossible with calculation groups

Sometimes we face models which can't be built because we fall into the circular relationship (which Power BI protects us against) or ambiguity (which sits there silently making all our results meaningless). I faced one of this situations the other day at work and found a workaround with --you guesse...
Leer post →
Power BI

Sorting a Parent-child defined Hierarchy

This is one problem that you don't realize it's a problem until you face it. Happened to me designing a P&L report. For this report, an arbitrary list of items (arbitrary to me of course) has to be displayed in certain order, each with it's own arbitrary calculation, and even with some hierarchy...
Leer post →