Forum Discussion

Gareth_Hunt's avatar
Gareth_Hunt
Icon for Helper II rankHelper II
6 years ago
Solved

DAX Code re-running sub total rather than summing

we have a dax code that runs to calculate revenue variance when we look at the sub total  the dax code is re running the equation rather than summing the values with in that catagory     CY_QT...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi Gareth_Hunt ,

     

    Please use SUMX function to have a try.

    Measure = SUMX(your_table,the_measure_need_to_be_summed)

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Gareth_Hunt ,

 

Please use SUMX function to have a try.

Measure = SUMX(your_table,the_measure_need_to_be_summed)