cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## 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 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.

1 ACCEPTED SOLUTION
Solution Sage

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

2 REPLIES 2
Solution Sage

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

Helper I

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%

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors