cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Re: Cumulative dax query help

Hi @mwegener 

 

Ssas 2016

 

Report server - Jan 2020 Version

Highlighted
Super User III
Super User III

Re: Cumulative dax query help

Hi @GuestUser ,

 

the same problem is described here.

https://community.powerbi.com/t5/Service/Running-Total-Issue/td-p/964702

Unfortunately, the SELECTEDVALUE solution is only available from SSAS 2017.

https://dax.guide/selectedvalue/

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
twitter - LinkedIn - YouTube - website

Highlighted
Helper V
Helper V

Re: Cumulative dax query help

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] )
    )
)

 

View solution in original post

Highlighted
Community Support
Community Support

Re: Cumulative dax query help

Hi @GuestUser ,

 

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

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Helper V
Helper V

Re: Cumulative dax query help

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?

 

 

Highlighted
Super User III
Super User III

Re: Cumulative dax query help

Hi @GuestUser,

 

can you provide a screenshot?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
twitter - LinkedIn - YouTube - website

Highlighted
Helper V
Helper V

Re: Cumulative dax query help

withoutfilter.jpgWithFilter.jpg

Highlighted
Helper V
Helper V

Re: Cumulative dax query help

Hi @mwegener

 

First screenshot is without any filter condition added -- it giving correct result

 

Second one - Added filter condition on filter pane ..like trx count is not blank...it gives incorrect result

 

basically i do not need those items in the report with trx count blank

 

Any suggestions pls

Highlighted
Super User III
Super User III

Re: Cumulative dax query help

Hi @GuestUser ,

 

can you post the DAX formula for both measures?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
twitter - LinkedIn - YouTube - website

Highlighted
Helper V
Helper V

Re: Cumulative dax query help

Hi,

 

1) Cumulative = calculate( table[trx count],

filter

(allselected(item[item_name]),

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

))

 

2) Trx Count = sum(table.item_count)

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors