Forum Discussion

JTESE's avatar
JTESE
New Member
7 years ago

Gantt Chart by MAQSoftware | Hierarchy Layout Rollup Calculation

I am having an issue with the roll-up totals when "Category > Hierarchy layout" is enabled and there is a Visual Level Filter or Page Filter applied.

 

Unfiltered it rolls up correctly:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

But once a filter is applied (in this case for values that are greater than zero), the rollup calculation is incorrect:

 

 

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi JTESE,

     

    What measure formula you used on this visual? Can you please share some sample data for test?

     

    BTW, if this formula works well on matrix subtotal, it should more related to visual itself. Please contact to visual author to report this issue.

    Clever Hierarchy Handling in DAX

     

    Regards,

    Xiaoxin Sheng

  • Quentin's avatar
    Quentin
    Icon for Helper IV rankHelper IV
    7 years ago

    I am facing exactly the same issue...

    Have you found some workaround or solutions?

    Thank you for sharing!
    Quentin

    • JTESE's avatar
      JTESE
      New Member
      7 years ago
      Unfortunately not... Please reply though if your luckier than I have been!
      • Quentin's avatar
        Quentin
        Icon for Helper IV rankHelper IV
        7 years ago

        In my case it's even worse as my labels are persentage of completion, therefore i would like the upper category not to sum on it but to do the average:

        result1 

        result1 Activity 1 progress 10%

        result1 Activity 2 progress 20%

         

        I would like progress of result1 to be 15%... 
        I sent a message to MAQSupport, let's see if they manage to help us