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 II

## SUm of percentage in table

hi

how to get this percentage into measure that will be used as line y-axis in visual

% policy count = DIVIDE(COUNT(tbl_purchase_journey[chdrnum]),calculate(COUNT(tbl_purchase_journey[chdrnum]),ALL(tbl_purchase_journey[TAT from Submit Date])),0)

thankyou,

1 ACCEPTED SOLUTION
Community Support

Hi, @Easley06

According to your formula, you can change it like this.

Measure:

``````% policy count =
DIVIDE (
COUNT ( tbl_purchase_journey[chdrnum] ),
CALCULATE (
COUNT ( tbl_purchase_journey[chdrnum] ),
ALL ( tbl_purchase_journey )
),
0
)
``````
``````% policy count2 =
SUMX (
FILTER ( ALL ( tbl_purchase_journey ), [TAT from Submit Date] <> ">2days" ),
[% policy count]
)
``````

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 REPLIES 3
Super User

@Easley06 , Try a measure like

sumx(Values(Table[Month]), [% policy count])

Helper II

Hi sir,

it works but how to filter out the >2 days

% policy count2 = calculate(sumx(Values(tbl_purchase_journey[TAT from Submit Date]), [% policy count]),FILTER(tbl_purchase_journey,tbl_purchase_journey[TAT from Submit Date] <> "> 2 days"))

thanks.
Community Support

Hi, @Easley06

According to your formula, you can change it like this.

Measure:

``````% policy count =
DIVIDE (
COUNT ( tbl_purchase_journey[chdrnum] ),
CALCULATE (
COUNT ( tbl_purchase_journey[chdrnum] ),
ALL ( tbl_purchase_journey )
),
0
)
``````
``````% policy count2 =
SUMX (
FILTER ( ALL ( tbl_purchase_journey ), [TAT from Submit Date] <> ">2days" ),
[% policy count]
)
``````

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.