Forum Discussion

timur-1993's avatar
timur-1993
New Member
2 years ago
Solved

Calculate column subtotal for ratio

Hi! I am new to DAX and Power BI. Please, would you please tell me how it should be done?   I am stuck with a problem.   I have a measure which should calculate sales forecast based on already g...
Need Help
  • BI-Leo's avatar
    BI-Leo
    2 years ago

    You can add a varible _Result = SUMX(VALUES('Table'[Month]), Forecast) and return it to see whether it works.

BI-Leo's avatar
BI-Leo
Frequent Visitor
2 years ago

Hi timur-1993 , this is due to Content Transition in the DAX, and the total won't simply add all the cell together.

For your scenario, the total calculates the result amonng whole sum sales in Nov and Dec then divide whole days in Nov and Dec.