Adding different Averages to a Combo Graph if the Slicer is Activated

[marie28]

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

[v-shex-msft · Accepted 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