Need help with blanks and zeros - calculation percentages by category

[The_Clam]

Hi.  I am have having trouble displaying blanks AND zeros in my Power BI percentage matix.  I seem to be able to display one or the other, but I need both.  I have 3 tables: Ticket Data, Severity, and Date (with relationships).  Tickets that have no data, I need to remain blank.  Ticket calculations that divide into zero, need to show zero.  See expected result below.  Thanks!

Expected Result:

Severity	January	February
Critical		0.00%
High		100%
Moderate		40%
Low

[jdbuchanan71 · Accepted solution]

@The_Clam try it like this.

Measure =
VAR _Under4 = COUNTROWS ( FILTER ( 'Ticket Data', 'Ticket Data'[Time to Resolve (hours)] < 4 ) )
VAR _Tickets = COUNTROWS ( 'Ticket Data' )
RETURN
    IF (
        ISBLANK ( _Tickets ),
        BLANK (),
        IF ( ISBLANK ( _Under4 ), 0, DIVIDE ( _Under4, _Tickets, 0 ) )
    )

[The_Clam]

Bingo!  Thanks so much.