Sum Filter the value in visual chart

[jayceeb]

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:

Date	Day	Time	Sample	Total
1-Aug	Tue	12:00:00 AM	Item 1	325
2-Aug	Wed	12:00:00 AM	Item 1	315
3-Aug	Thu	12:00:00 AM	Item 2	340
4-Aug	Thu	3:00:00 AM	Item 2	285

Measure Item 1 =

CALCULATE(

    SUM('Equipment Query'[Total]),

    'Equipment Query'[Sample] IN {"Item 1"})

[jayceeb]

Hi my formula is the same.

However its shows different value if there is the same date.

Date	Day	Time	Sample	Total
1-Aug	Tue	12:00:00 AM	Item 1	325
2-Aug	Wed	12:00:00 AM	Item 1	315
3-Aug	Thu	12:00:00 AM	Item 2	340
4-Aug	Thu	3:00:00 AM	Item 2	285
1-Aug	Tue	3:00:00 AM	Item 1	10
1-Aug	Tue	6:00:00 AM	Item 1	200
1-Aug	Tue	9:00:00 AM	Item 1	200

[jayceeb]

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

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

[Mahesh0016]

@jayceeb I hope this helps you.

@jayceeb Thank You.

[Mahesh0016]

@jayceeb Please Can share your Endoutput in a table or on the chart? Thank You.