Forum Discussion
Help with Dax
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 |
1 Reply
BZerr824 - Get the MAX of DM column and then use ALL and then filter down your value for DM.
