SUMIF and COUNTIF

Hi Aditi_Saxena ,

Please try below steps:

1. below is my test table

Table:

Table2:

2. create measure with below dax formula

Sum Item Sold =
VAR cur_pt =
    SELECTEDVALUE ( 'Table'[Product] )
VAR tmp =
    FILTER ( ALL ( 'Table' ), [Product] = cur_pt )
RETURN
    SUMX ( tmp, [Items sold] )

Measure =
VAR tmp =
    SUMMARIZE ( 'Table', 'Table'[Product], "SUM_Sold", SUM ( 'Table'[Items sold] ) )
VAR _a =
    SELECTEDVALUE ( 'Table 2'[Column1] )
VAR _result =
    SWITCH (
        _a,
        "=0", COUNTROWS ( FILTER ( tmp, [SUM_Sold] = 0 ) ),
        "1-10",
            COUNTROWS ( FILTER ( tmp, [SUM_Sold] >= 1 && [SUM_Sold] <= 10 ) ),
        "11-20",
            COUNTROWS ( FILTER ( tmp, [SUM_Sold] >= 11 && [SUM_Sold] <= 20 ) )
    )
RETURN
    _result

3. add a table visual and clustered column chart with fields and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

Please find attached my PBI file.

Hope this helps.