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 IV
Super User IV

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
"Get the most out of data, with Power BI."
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 IV
Super User IV

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
"Get the most out of data, with Power BI."
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 IV
Super User IV

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
"Get the most out of data, with Power BI."
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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors