Help with Dax

BZerr824 — Wed, 08 Jul 2020 20:33:00 GMT

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

Re: Help with Dax

Greg_Deckler — Wed, 08 Jul 2020 21:06:58 GMT

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

topic Help with Dax in DAX Commands and Tips

Help with Dax

Re: Help with Dax