Forum Discussion

GuestUser's avatar
GuestUser
Helper V
6 years ago
Solved

Cumulative dax query help

Hi We are using power bi with ssas tabular model using connect live option. Need help in cumulative column Report format is as below Matrix view Year. 2018. 2019 Item. Trxcount. Cumulative T...
Need Help
  • GuestUser's avatar
    GuestUser
    6 years ago

    Hi mwegener 

     

    @Thanks for your inputs!!

    Used below formula(similar)..replaced selected value by hasonevalue and it worked..

     

    Thanks !!

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

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi GuestUser ,

 

I am currently not working with SSAS Tabular, but it is documented in the DAX Guide as follows.

Returns the largest value in a column, or the larger value between two scalar expressions. Ignores logical values. Strings are compared according to alphabetical order.

https://dax.guide/max/

 

Which version are you using?

 

 

GuestUser's avatar
GuestUser
Helper V
6 years ago

Hi mwegener 

 

Ssas 2016

 

Report server - Jan 2020 Version

    • GuestUser's avatar
      GuestUser
      Helper V
      6 years ago

      Hi mwegener 

       

      @Thanks for your inputs!!

      Used below formula(similar)..replaced selected value by hasonevalue and it worked..

       

      Thanks !!

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

       

      • v-eachen-msft's avatar
        v-eachen-msft
        Community Support
        6 years ago

        Hi GuestUser ,

         

        I am glad that your problem has been resolved, you could accept your own reply to close the case.