Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
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
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%
User | Count |
---|---|
134 | |
68 | |
68 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |