Home Forums Data Warehousing Analysis Services Use DAX to create measures in Tabular Model that will apply different logic at each level of heirarchy. Can it be done? RE: Use DAX to create measures in Tabular Model that will apply different logic at each level of heirarchy. Can it be done?

  • March 23, 2016 at 9:53 am

    #1867145

    Thanks Brian.

    BTW, I attended a PowerPivotPro users meeting in Redmond yesterday and regarding ISFILTERED syntax for applying logic at different levels of hierarchy, I was advised as best practice to always supply the lowest hierarchy item as the first ISFILTERED condition, and to travel up the hierarchy.

    I have not actually testing to see if this made a difference for me but I thought I would post this in case someone else reads.

    --Quote me