Help with Dax

[BZerr824]

Hi Everyone,

I need help!  We use live connection to an SSAS tabular model for our Power BI reports, but sometimes have to create addtional formulas within specific reports.
I'm trying to get a total for one level of a location hierarchy and I need that total to be displayed no matter what level the report is actually at (i.e. I need the same total to repeat for all records. )  Here is example of what I need.  Hopefully this makes sense!  Basically I need "New Metric" to stay at the DM level, no matter what level the report is at.  Thanks in advance for your help!!

Slicer may be on DM or a Store, but want new metric to remain same
District Mgr	Store name	Store count	Metric 1	New metric
Bob	Store 1	1	4	2.25
Bob	Store 2	1	2	2.25
Tim	Store 3	1	1	0.75
Amy	Store 4	1	3	3
Amy	Store 5	1	8	3
Amy	Store 6	1	1	3
Calculate 75% of  Average Metric 1 per DM
Bob	2.25		75% of the average of metric 1 per DM
Tim	0.75
Amy	3

[Greg_Deckler]

@BZerr824  - Get the MAX of DM column and then use ALL and then filter down your value for DM.