SUm of percentage in table

[Easley06]

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,

[amitchandak]

@Easley06 , Try a measure like

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

[Easley06]

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.

[v-zhangti · Accepted solution]

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.