Sum of value in filter

[Sar_Aan]

The quantity has multiple values occuring on a single date and I wanted to find out the count of resources where the sum for a day is more than 23.

Data:

Date	Resource	Quantity
4-1-2023	A	17
4-1-2023	B	24
4-1-2023	A	6
4-1-2023	C	15
4-1-2023	A	1
5-1-2023	A	16
5-1-2023	B	24
5-1-2023	A	4
5-1-2023	C	10
5-1-2023	A	4

Instead of giving count as 1 (only A) on 4-1-2023 and 5-1-2023 I want the result to be 2 (A & B) as sum of quantity of B is more than 23 (24).

What should I do?

Thanks in advance

[FreemanZ · Accepted solution]

hi @Sar_Aan ,

try to plot a table visual with date column and a measure like:

measure = 
COUNTROWS(
    FILTER(
        VALUES(data[Resource]), 
        CALCULATE(SUM(data[Quantity]))>23
    )
)

it worked like:

[Sar_Aan]

And I need to show the count for the month of April which should be 4.