Forum Discussion
Summarize results
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.
Sorry, I'm not sure I understand what the question is? Are you able to use a matrix visualization for this?
Try using ALLEXCEPT(Fact[Diet]) in your measure if you still need the qty and other info in the table too:
Final Diet = CALCULATE([final], ALLEXCEPT(Fact[Diet]))
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 |
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.