Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
@BZerr824 - Get the MAX of DM column and then use ALL and then filter down your value for DM.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |