Report Portal

Dealing with Blanks Ragged Hierarchies in PowerBI (ISINSCOPE)

While the Matrix Control does has some new features for automatically handling ragged hierarchies as described by Reza Rad and others  (https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual), it falls short of what we want to achieve on most of my projects and still doesn’t come up to where MOLAP was with its automatic support via HideMemberIf

This is the approach that I use, and I was pleased to see that DAX patterns second edition also has this type of design pattern.

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.