Forum Discussion

CVance's avatar
CVance
Frequent Visitor
5 years ago

Multi-tenancy and the Hierarchy Control

I have a multi-tenant application, and I want to use the Hierarchy control as a slicer for choosing various levels in an organization. I'm following the instructions for creating the hierarchy contro...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi CVance ,

 

Build a standard model of hierarchical structure in the data model. If a tenant has no value at a certain level, use a null value instead.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

cvance5's avatar
cvance5
Frequent Visitor
5 years ago

Hi v-lionel-msft 

 

Thank you for your reply, but how do I do that?

Here's the Dax for Level 3 of the hierarchy:

Level3 = 
VAR LevelNumber = 3
VAR LevelKey = PATHITEM ( MyHierarchy[EntityPath], LevelNumber, INTEGER )
VAR LevelName = LOOKUPVALUE ( MyHierarchy[Name], MyHierarchy[ID], LevelKey )
VAR Temp = IF(ISBLANK(LevelName), NULL, LevelName)
VAR Result = Temp
RETURN
    Result

 

This results in an error message: "Operator or expression 'NULL' is not supported in this context."

 

How else do I use NULL when there is no value in the row at the hierarchy level?

Thanks!

Chris