Forum Discussion

GuestUser's avatar
GuestUser
Icon for Helper V rankHelper V
6 years ago
Solved

Running Total Issue

Hi ,   Need help in creating running total column We are creating report using Connect Live option - SSAS Tabular   I have report in below format   Category  Name  Sales  RTotal ABC          ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    Hi, GuestUser 

    Please provide more details .（Where did you write your measure）

    Theoretically  no matter in the directquery  or live connect mode, Selectvalue function all can be recognized in  PowerBI Desktop.

     

     

    Best Regards,
    Community Support Team _ Eason

GuestUser's avatar
GuestUser
Icon for Helper V rankHelper V
6 years ago

Hi,

 

I dont think isssue is with Sales Column.

 

Let me try to explain again :

 

When I select - New Quick Measure - RunningTotal . It assks for following things

 

Base value -  Sales Amount

Field - Category  ( It takes only columns and not measures)

Direction - Descending

 

and it will create measure with below formula

Measure =

CALCULATE(
    [Sales],
    FILTER(
        ALLSELECTED('Table'[Category]),
        ISONORAFTER('Table'[Category], MAX('Table'[Category]), DESC)
    )
)

Which is giving error - like MAX cannot work on String Data Types

 

Hope I am clear.

 

Any suggestions . Basically i need to achieve cumulative Total .

Any other formula /way to achieve the same ?

 

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

Hi , GuestUser 

 

Try   measure as  below:

Measure =
CALCULATE (
    [Sales],
    FILTER (
        ALLSELECTED ( 'Table'[Category] ),
        'Table'[Category] <= SELECTEDVALUE ( 'Table'[Category] )
    )
)

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • GuestUser's avatar
    GuestUser
    Icon for Helper V rankHelper V
    6 years ago

    Thanks v-easonf-msft 

     

    Selectvalue function is not recognized in the version of dax which i am using

     

    Any other alternative pls?

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

      Hi, GuestUser 

      Please provide more details .（Where did you write your measure）

      Theoretically  no matter in the directquery  or live connect mode, Selectvalue function all can be recognized in  PowerBI Desktop.

       

       

      Best Regards,
      Community Support Team _ Eason