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.
AllisonKennedy
Community Champion
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.