Forum Discussion

chesterraepined's avatar
chesterraepined
Helper I
8 years ago
Solved

Need a measure for table visual

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...
Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    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 

Interkoubess's avatar
Interkoubess
Solution Sage
8 years ago

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's avatar
chesterraepined
Helper I
8 years ago

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%