Forum Discussion
Solved
HOW TO CREATE MEASURE OF TOTAL SALES AMOUNT PER REGION, REGION IS IN ANOTHER TABLE
TOTAL SALES IS A MEASURE WHICH IS IN TABLE 1
REGION IS IN TABLE 2 , table 2 has a relatiohship with table 1 though city
TRYING TO CREATE TOTAL SALES MEASURE ONLY FOR EAST REGION
| CITY | Region |
| A | EAST |
| B | WEST |
| C | SOUTH |
| D | NORTH |
| E | NORTH |
| F | EAST |
| G | WEST |
| H | SOUTH |
| I | WEST |
| J | EAST |
| K | SOUTH |
| L | EAST |
Hi,
try this:
EastSales := calculate(sum('Table 1'[Sales]),'Table 2'[Region]="EAST")If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
1 Reply
- serpiva64
Solution Sage
Hi,
try this:
EastSales := calculate(sum('Table 1'[Sales]),'Table 2'[Region]="EAST")If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !