Forum Discussion
Solved
Stacked Column Chart with Aggregated Data
Hi! I have two tables linked with the tblOrder_ID tblOrder ID 1 2 3 tblOrderTask tblOrder_ID DeltaDays 1 -4 1 0 1 5 2 4 2 0 3 2 3 2 3 6 3...
Hi bga1 ,
Based on your data, I created below chart, hope that's what you want:
I created 4 measure:
Measure 6 = CALCULATE(MIN('Table (3)'[DeltaDays]),ALLEXCEPT('Table (3)','Table (3)'[tblOrder_ID])) BLUE = CALCULATE(DISTINCTCOUNT('Table (3)'[tblOrder_ID]),FILTER('Table (3)',[Measure 6] < 0)) DARK BLUE = CALCULATE(DISTINCTCOUNT('Table (3)'[tblOrder_ID]),FILTER('Table (3)',[Measure 6] = 0)) ORANGE = CALCULATE(DISTINCTCOUNT('Table (3)'[tblOrder_ID]),FILTER('Table (3)',[Measure 6] > 0))Please try.
Aiolos Zhao
Hi bga1 ,
Based on your data, I created below chart, hope that's what you want:
I created 4 measure:
Measure 6 = CALCULATE(MIN('Table (3)'[DeltaDays]),ALLEXCEPT('Table (3)','Table (3)'[tblOrder_ID]))
BLUE = CALCULATE(DISTINCTCOUNT('Table (3)'[tblOrder_ID]),FILTER('Table (3)',[Measure 6] < 0))
DARK BLUE = CALCULATE(DISTINCTCOUNT('Table (3)'[tblOrder_ID]),FILTER('Table (3)',[Measure 6] = 0))
ORANGE = CALCULATE(DISTINCTCOUNT('Table (3)'[tblOrder_ID]),FILTER('Table (3)',[Measure 6] > 0))
Please try.
Aiolos Zhao
Anonymous
Thank you so much for the support so far
I have one additional question:
Measure 6 = CALCULATE(MIN('Table (3)'[DeltaDays]),ALLEXCEPT('Table (3)','Table (3)'[tblOrder_ID]))
Lets assume we have another column [Status] in Table (3).
What do I have to change in this measure, when I want to only consider values for this measure that have [Status] 1 or 8?