Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
2 years ago

time frame recommendation

I have a list of stores with respective interval (time) and Avg Volume of calls.  I am trying to acheive the columns on the right where we want to see how many of those intervals go over threshold (b...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

jcastr02 , check if these columns and measures can help

 

new columns
Total Intervals = COUNTROWS(FILTER('Table', 'Table'[Store #] = EARLIER('Table'[Store #])))

 

I ntervals Over Threshold =
IF('Table'[Avg Volume/Interval] > 10, 1, 0)


new measures
% Intervals Over Threshold =
DIVIDE(SUM('Table'[Intervals Over Threshold]), SUM('Table'[Total Intervals]), 0)


Recommendation =
IF(MAX('Table'[% Intervals Over Threshold]) = [ % Intervals Over Threshold], "x", BLANK())

  • jcastr02's avatar
    jcastr02
    Post Prodigy
    2 years ago

    Hi amitchandak Thank you - How would I get the grouping , for example above the 3-10pm range would be the highest.         (the last 4 columns on here are independent of the first 4 columns  (essentially two tables)