DAX Count Formula for a Specified Row

Hello

To get the total for casual and SL, open a matrice put the column To Type in it and the measur I gave you. it will give you the total

Hi, juhoneyighot 

Pls have you solved this problem now? you can refer to JamesFR06 reply, thanks for your positive reply. If it doesn't solve the problem, you can refer to my method below.

Time Off Type = 
IF(
    'Table'[Description] = BLANK()
    ||'Table'[Type] = BLANK()
    ||'Table'[Status] = BLANK(),
    BLANK(),
    IF(
        'Table'[Type] = "Vacation"
            && 'Table'[Description] = "Sick Leave"
            && 'Table'[Status] = "Approve",
        "Sick Leave",
        "Casual"
    )
)

count of Casual = 
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( 'Table', 'Table'[Time Off Type] = "Casual" )
)

count of Sick Leave = 
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( 'Table', 'Table'[Time Off Type] = "Sick Leave" )
)

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum