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

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

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

    Hey, BI-Leo!

    This worked just fine, thanks a lot!

    Could you give advice on what to read to better understand how to manipulate totals?