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 ...
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.

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.