Forum Discussion

Rajiv1237's avatar
Rajiv1237
Icon for Resolver I rankResolver I
9 years ago
Solved

Running total through direct query mode in PowerBI

I can't find a way to calculate a running total, without using FILTER. Filter is not supported in PowerBi direct query-mode. All help is appreciated   Not supported in Direct Query Mode :(   Run...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Rajiv1237,

     

    Did you turn on the "allow unrestricted measures in directquery mode" option? If not you can turn on it first.

    In addition, my formual is a measure, don't put it in calculate column.

     

    Regards.

    Xiaoxin Sheng

  • Rajiv1237's avatar
    Rajiv1237
    9 years ago

    RunningTotalinPowerBI = SUMX(FILTER(ALLSELECTED(YearQty), YearQty[DateKey]<=MAX(YearQty[DateKey])), YearQty[Qty])

     

    Filter works in Direct Query Mode: We have to check the option in Power BI desktop ‘Allow unrestricted measures in DirectQuery mode’

     

    File -> Option and settings -> Option

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Rajiv1237,

 

Did you turn on the "allow unrestricted measures in directquery mode" option? If not you can turn on it first.

In addition, my formual is a measure, don't put it in calculate column.

 

Regards.

Xiaoxin Sheng

Rajiv1237's avatar
Rajiv1237
Icon for Resolver I rankResolver I
9 years ago

RunningTotalinPowerBI = SUMX(FILTER(ALLSELECTED(YearQty), YearQty[DateKey]<=MAX(YearQty[DateKey])), YearQty[Qty])

 

Filter works in Direct Query Mode: We have to check the option in Power BI desktop ‘Allow unrestricted measures in DirectQuery mode’

 

File -> Option and settings -> Option