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 Amt" for that group which is working as you  can see in the picture but we also want t it to have the "Name" that is associated with the "Max Amt", so for example the second group "AF264058      GS     2.02"     should be      "AF264058      JPM     2.02"  another example is the third group "AM103318  CIBC   1.76"  should be "AM103318  SCM   1.76"   

 

We tried many different visuals and cant seem to solve this any help would be appreaicted!

 

Thanks

 

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.

3 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.