Forum Discussion

GuestUser's avatar
GuestUser
Icon for Helper V rankHelper 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] )
    )
)

     

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

hi,

 

facing some strange behaviour

 

the below formula works

Cumulative = calculate( table[total sales],

filter

(allselected(item[item_name]),

item[item_name]<=if(hasonevalue(item[item_name]),values(item[item_name])

))

 

when i dont put any filter condition on total sales..cumulative value is correct...but it shows item with no sales as well

 

So when i put filter condition as total sales is not blank in report ,

then the cumulative value shows wrong value..it shows correct for 2 records..then the third record..it shows the same value as total sales

 

Any suggestions pls?

 

 

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi GuestUser,

 

can you provide a screenshot?