getting percentage in matrix

[Easley06]

Hi,

would like to ask help for this problem i have matrix table but i want to put it in measure getting only the percentage of  1 and 2 

current measure: 

% policy count = DIVIDE(COUNT(tbl_purchase_journey[chdrnum]),calculate(COUNT(tbl_purchase_journey[chdrnum]),ALL(tbl_purchase_journey[adjusted_issued_within_2_days])),0)

the measure will be used as line y-axis 

thanks

[FreemanZ]

you shall be able to filter out the ">2 day" in the filter pane, or 

[FreemanZ]

or try to wrap your measure with IF condition, like this:

% policy count = 

IF(

    VALUES(tbl_purchase_journey[adjusted_issued_within_2_days]) = "> 2 days",

    BLANK(),

    DIVIDE(

          COUNT(tbl_purchase_journey[chdrnum]),

          CALCUALTE(

                COUNT(tbl_purchase_journey[chdrnum]),

                ALL(tbl_purchase_journey[adjusted_issued_within_2_days])

          ),

          0

    )

)

[Easley06]

Hi sir, 

i will use the measure for this table. for line y-axis