Forum Discussion

jayceeb's avatar
jayceeb
Helper I
3 years ago

Sum Filter the value in visual chart

Hi, I have 02 column chart to see the total of  per date,day or per hour.

how to get the sum value by filtering because the measure I make shows different value.

thank you in advance..

My table:

DateDayTimeSampleTotal

1-Aug

Tue12:00:00 AMItem 1325
2-AugWed12:00:00 AMItem 1315

3-Aug

Thu12:00:00 AMItem 2340
4-AugThu3:00:00 AMItem 2285

 

Measure Item 1 =
CALCULATE(
    SUM('Equipment Query'[Total]),
    'Equipment Query'[Sample] IN {"Item 1"})

 

 

 

"Calculated Column"
chart
Chart Help

4 Replies

  • jayceeb's avatar
    jayceeb
    Helper I
    3 years ago

    Example I select date from Aug 1 and Aug 2 @ 12:00am

    I want the Item 1 value to show as 325 and 315.

     

     

  • jayceeb's avatar
    jayceeb
    Helper I
    3 years ago
    Hi my formula is the same.
    However its shows different value if there is the same date.
     
    DateDayTimeSampleTotal
    1-AugTue12:00:00 AMItem 1325
    2-AugWed12:00:00 AMItem 1315
    3-AugThu12:00:00 AMItem 2340
    4-AugThu3:00:00 AMItem 2285
    1-AugTue3:00:00 AMItem 110
    1-AugTue6:00:00 AMItem 1200
    1-AugTue9:00:00 AMItem 1200