Counting the number of time a dynamic category appeared

[spartansquad]

Hello Everyone, 
I hope you are all doing well,
I am stuck at a problem and can't find a ways out. I have a sample table with shops name, target and date. Based on the target a dax measure is written which which will define the category for that particular shop.
for example if I select date between 1 december, 20222 to 2 decemeber 2022 than the category of  a1 store will be "D" however if choose date upto 3 december , 2022 the category of a1 store will be "A".   Following dax is used to assign the category.

-------------------------------------------------------------------------------

Category =

var t1 = sum('Table'[Target])

return

if(t1 >=15 ,"A", if(t1<15 && t1>=10, "B", if(t1>10 && t1<=5, "C","D")))

--------------------------------------------------------------------------------

Now I want to count the total number of stores fall in a specefic category based show the total against those stores with respect to the chosen date and show blank in total for category and for count. 

The output should be like this.

Kindly help

[spartansquad]

It worked for me thank you

[tamerj1 · Accepted solution]

Hi @spartansquad 
Please refer to attached sample file with the solution

Count of Category = 
VAR CurrentCategory = [Category]
RETURN
    SUMX ( 
        ALLSELECTED ( 'Table'[Shop] ),
        IF ( 
            [Category] = CurrentCategory,
            1
        )
    )