Need total in the table and average in totals

[SwathiGanesh]

I am working on one peculiar request,
We are using parameter in the table and we need totals in the rows and average in the totals.
Table is this format:

Partnername Partnertype Partnercountry Salary

A	MVA	uk	1000
B	DVP	us	2000
A	MVA	us	3000
C	MVN	uk	1000
A	MVP	uk	1000

Parameter are : We have a slicer on the page
☑️Partnername
⏹partnerTYPE
☑️partnercountry

The formula should consider all three columns[Partnername partnerTYPE partnercountry ]
I need result like this:

Partnername Partnercountry Salary

A	uk	2000
B	us	2000
A	us	3000
C	uk	1000
Total		2000

Tried this formula:
if(
Hasonevalue(parntername),
sum (salary),
average(salary))
But it's not working

[ChrisMendoza · Accepted solution]

Try using ISINSCOPE like:

Measure ISINSCOPE = 
IF(
    ISINSCOPE(TableName[Partnername]),
    SUM(TableName[Salary]),
    AVERAGE(TableName[Salary])
)

[SwathiGanesh]

I am stuck and unable to find how to make “VAR SUMMERISE” to work, this variable should summerize the selected columns only. I am using this to find the denominator.
It works fine when all three columns are selected, but I need to summerize based on the selected column

Uniques =
var sumfc= sum (salary),
VAR SUMMERISE = SUMMARIZE(Partnername,Partnercountry, partnerTYPE, “Average”,sumfc)
return
IF(
OR(ISINSCOPE( 'Partnername),OR(ISINSCOPE( 'Partnercountry),ISINSCOPE(partnerTYPE))),
sum (salary),
DIVIDE(sumfc,COUNTROWS(SUMMERISE ))

)