Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I am struggeling to add 2 different averages to a combo chart if the slicer is activated. The following 2 averages are calculated as a DAX measure and I would like them to adjust on the graph as the slections in the slicer change. Do you have any ideas on how I would need to adjust the formula for the calculated averages to make sure it is a dynamic measure? I would like to see the 2 average values either as a column or line in the combo chart.
- Average of Sales by City (= Peekskill)
- Average of Sales by County (= Westchester)
The x-axis would display the sales reps and the primary y-axis shows the completed sales and the secondary y-axis shows the sales revenue.
Sales Rep | City | County | State | # of Sales Completed | Total Sales Revenue ($) |
D | Mount Vernon | Westchester | NY | 3 | $600 |
E | New Rochelle | Westchester | NY | 8 | $1,500 |
F | Peekskill | Westchester | NY | 2 | $500 |
H | Peekskill | Westchester | NY | 2 | $1,000 |
Average for Peekskill | Westchester | NY | 2 | $750 | |
Average for Westchester | Westchester | NY | 4 | $900 | |
J | Oswego | Oswego | NY | 1 | $500 |
G | Oswego | Osewgo | NY | 6 | $1,200 |
A | Long Island | Nassau | NY | 15 | $6,000 |
C | Glen Cove | Nassau | NY | 5 | $2,000 |
B | Albany | Albany | NY | 12 | $4,000 |
I | Watervliet | Albany | NY | 4 | $1,200 |
Thanks for yoru help in advance,
Marie
Solved! Go to Solution.
Hi @marie28 ,
Nope, you can't direct edit data model table records.
Maybe you can try to use union function to create a new table to manually append custom records with original table records.
Table 2 = UNION ( 'Table', UNION ( ROW ( "index", 4, "name", "SubTotal" ), ROW ( "index", 6, "name", "GrandTotal" ) ) )
Regards,
Xiaoxin Sheng
Hi @marie28 ,
Nope, you can't direct edit data model table records.
Maybe you can try to use union function to create a new table to manually append custom records with original table records.
Table 2 = UNION ( 'Table', UNION ( ROW ( "index", 4, "name", "SubTotal" ), ROW ( "index", 6, "name", "GrandTotal" ) ) )
Regards,
Xiaoxin Sheng
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |