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

Re: Cumulative dax query help

Hi @mwegener ,

 

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)

 

Highlighted
Super User IV
Super User IV

Re: Cumulative dax query help

Hi @GuestUser ,

 

I don't understand why the "cumulative count" for some items in screenshot is 0.

Here I would expect the value of the previous item.

 

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!!

 

Changed formula for Trx Count 

Trx_Count = if(sum(Table[Item_count]) = blank(),0,sum(table[item_count])) ----  Shows 0 instead of blank

And Cumulative values show..previous value where Trx_Count is 0

 

But still I am not able to get rid of records having Trx_Count=0 , when i apply filter..it gives incoorect cumulative value...as posted in previous screenshot

Highlighted
Super User IV
Super User IV

Re: Cumulative dax query help

Hi @GuestUser 

 

I have created the following sample PBIX.
Why are these rows in your screenshot 0?

CumTrxItem.png

 

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

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

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