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

     

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

Its DirectQuery Mode not Loading the data into PowerBI.

 

Filter function doesn't work in PowerBI Direct Query Mode

 

Filter function doesn't work in Direct Query Mode

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