Matrix Hierarchy Header Row

[UpNorth]

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

[Anonymous · Accepted solution]

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]

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]

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