Need a measure for table visual

[chesterraepined]

I need a measure that will show the percentage for only "Hit" and "Missed" and then blank or 0 will show for "No deadline set". 

The computation for Hit should be Request Completed divided by Sum of Hit and Missed (2318 / 2524 =  0.92). Same with Missed it should be (206 / 2524 = 0.08).

Target = column

Request Completed = COUNTROWS(CustomerUpdates)

Hope this is possible.

Thanks in advance!

[Interkoubess · Accepted solution]

Hi @chesterraepined,

Please try this measure with my table called Table1:

Measure  = if(SELECTEDVALUE(Table1[target])="No deadline set", 0,DIVIDE(SUM(Table1[Requested Completed]),CALCULATE(SUM(Table1[Requested Completed]), Table1[target] in {"Hit","Missed"}),BLANK()))

Hope it helps but experts can find more elaborate formula for you.

Ninter 

[chesterraepined]

Hi @Interkoubess thanks for the reply.

The measure seems fine but the total is somehow different. The total 5708 was also divided to the sum of Hit and Missed (5708 / 2524 = 226.15%) . The Total should only be 100%