cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jeffbeckinc Frequent Visitor
Frequent Visitor

Sum/Ratio problem

I have location I am trying to set a min and max up for a shipping schedule.  If filtered for a single day, everything looks fine but when include multiple days (like 5 days as shown in table below), start seeing inbound as a ratio of "Actual Total".

For example, Actual Daily Min top line has 19 for daily min, but over a 5 day period it multiplying 19 * 60 (or the Actual Total) to get 1140 where I just want it to be : 19 *5  . In this example I want the total to reflect 19*5 or 95.

 

I have a lookup value for the Actual Daily Min that inputs a value for every row in my table so I imagine I need to create a measure to accomplish my 19 *5 or whatever total based on date range.  That is where I am stuck.

 

Thank you for looking and appreciate any guidance you can provide

 

Sum Ratio 2.PNG

4 REPLIES 4
Super User III
Super User III

Re: Sum/Ratio problem

What are the current measures you're using?  I'm most interested in how you're calculating [Actual Total] and [Incorrect 5 day Min Inbound]

jeffbeckinc Frequent Visitor
Frequent Visitor

Re: Sum/Ratio problem

Actual Total is a distinct count of shipment numbers

 

Incorrect 5 day Min Inbound is from a Lookup Value from a static table  that will be updated monthly

Super User III
Super User III

Re: Sum/Ratio problem

So then wouldn't the fix be updating your static table with the correct values?

jeffbeckinc Frequent Visitor
Frequent Visitor

Re: Sum/Ratio problem

I don't believe so because it will change depending on how it is filter; day, week, month. 

 

It is setup in the static table to be daily. 

 

I believe I need to create a measure to avoid the calculated column, row by row taking the lookup value found in the static table and multipling by number of loads. 

 

For example: I want it to calculate 5 days times 4 loads minimum a day for total of 20 loads in a 5 day period but it is taking 4 load minimum per day and multiplying by 9 loads(since 9 loads actually shipped over the 5 day period).

 

 

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors