Forum Discussion

UpNorth's avatar
UpNorth
Regular Visitor
4 years ago
Solved

Matrix Hierarchy Header Row

Good day Power BI Community,   This is my first post/question hope this works.   We are using the Matrix Visual on a dashboard and are trying to have the header row for each group have the "Max A...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi hannax123 ,

     

    Method1: Go to Modeling tab:

    Method2: Right-click the Table name:

     

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi UpNorth ,

 

You could use ISINSCOPE() to change the sub-total value of Rows in Matrix visual:

Name of Max Amt = 
var _maxAmt = MAXX(FILTER(ALL('Table'),[ID]=MAX('Table'[ID])),[Max Amt])
var _maxName= CALCULATE(MAX('Table'[Name]),FILTER('Table',[ID]=MAX('Table'[ID])&& [Amt]=_maxAmt)) 
return IF(ISINSCOPE('Table'[Time]),MAX('Table'[Name]),_maxName)

Output:

 

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

  • hannax123's avatar
    hannax123
    Regular Visitor
    4 years ago

    Hi there - We are using Direct Query and there is no Data tab to enter in the DAX formulas. Is there another way to enter DAX?

     

    Thanks,

    Hanna