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.
Community ChampionSorry, 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]))
I tried using AllExcept.
I simply need the final result which is
Veg : Final = 800
N Veg : Final = 100
My model is doing (20+30)*(10+20) which gives me 1500.
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-msftCommunity Support
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.
