total value corner matrix

[Anonymous]

Hi,

I decided to post this as a new topic since i a different problem than before.

As you can see below  the total in the corner is 35 so the value I got is 15.10%. 

However, this value I need it to be the sum of the 3 items (in this case) divided by 3items  OR the sum of each value per day divided by number of days. 

As is it the value of totals in the corner, I dont know how to change only this number without affecting thte total row /column.

do you have any idea to sort out this problem?

thanks!

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Try this.

create the measure:

Measure = IF(ISINSCOPE('Table'[storecity])||ISINSCOPE('Table'[orderdate]),SUM('Table'[salesvolume]),"input value you want")

Result:

See sample file attached bellow.

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.