Group by with If Condition

Hi bhavinshah 
You can use 2 measures for the new columns. check the output first and then try the DAX code for measures.
TBL7 is my table name.

First measure the count all the values (Y and N both)

TBL7 Total Count = COUNTROWS(TBL7)

After that filter out the Y rows and then count the rows.

TBL7 Count Y = 
VAR ValuesY =
FILTER(
    TBL7,
    TBL7[Status] = "Y"
)
VAR ValuesCount =
COUNTROWS(ValuesY)
RETURN
ValuesCount+0

Dear bhavinshah ,

Please find below a possible solution.

This measure is for the Group measure.

This is for the Count measure.

Count =

VAR selItem = SELECTEDVALUE('My table'[Status])

VAR Yes_ =

IF(

    selItem = "N",

    0,

    CALCULATE(

        COUNTROWS('My table'),

        FILTER('My table',

        'My table'[Status] = "Y"))

)

RETURN

Yes_

 

*****Please accep this as a solution****