Forum Discussion
Solved
Summarize results
I have a data model with 3 tables 1) ForecastPlan Product No Forecast Plan 1 10 2 20 2) fact Product No Diet Qty Needed (a) 1 Veg 20 2 Veg 30 3 N Veg 1...
Hi hitesh160790 ,
I have created a sample. I'm not clear how you want to show.
If you want to show in table visual, please try this:
Measure = SUM('Fact'[Qty Needed (a)])* SUM(ForecastPlan[Forecast Plan]) Measure 2 = SUMX(ALLEXCEPT('Fact','Fact'[Diet]),[Measure])If you do it in matrix visual, please try:
Measure 3 = SUMX('Fact',[Measure])For more details, please see the attachment.
If I use matrix I am getting
| Product No | Qty Needed (a) | Forecast Plan (b) | Component | Final (a*b) |
Veg (Diet) 1 (Product No) 2 (Product No) | 20 30 | 10 20 | C1 C1 | 200 600 |
TOTAL | 50 | 30 |
| 1500 |
I need
| Product No | Qty Needed (a) | Forecast Plan (b) | Component | Final (a*b) |
Veg (Diet) 1 (Product No) 2 (Product No) | 20 30 | 10 20 | C1 C1 | 200 600 |
TOTAL |
| No Total Here |
| 800 |
v-xuding-msft
Community Support
Community SupportHi hitesh160790 ,
I have created a sample. I'm not clear how you want to show.
If you want to show in table visual, please try this:
Measure = SUM('Fact'[Qty Needed (a)])* SUM(ForecastPlan[Forecast Plan])
Measure 2 = SUMX(ALLEXCEPT('Fact','Fact'[Diet]),[Measure])
If you do it in matrix visual, please try:
Measure 3 = SUMX('Fact',[Measure])
For more details, please see the attachment.