Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

total value corner matrix

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!

Need Help
  • v-xiaotang's avatar
    v-xiaotang
    5 years ago

    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.

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    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.