Calculate Filled Rate in a calculate column

[Anonymous]

Hi all,

Though this question is related my previous post, im creating a new post as the idea im trying to achieve is different. Below is the data that i have in my model in powerbi.

I need to calculate Filled Rate that is "count of orderid with status filled / total orders.  I need this filled rate as a slicer so that my other visuals gets filtered based on this fill rate. So, i need this filled rate in column rather than a measure.

Kindly help me how can i achieve this.

source	OrderID	orderstatus
Amrutha	1	Cancelled
Amrutha	2	Filled
Frank	3	Closed
Frank	4	Halted
Frank	5	Submitted
LS	6
LS	7	Cancelled
LS	8	Closed
LS	9	Deleted
LS	10	Filled
LS	11	Open
LS	12	Pending
LS	13	Scheduled
LL	14	Cancelled
LL	15	Closed
LL	16	Filled
LL	17	Open
LL	18	Pending Fill
SW	19	Filled

[amitchandak]

@Anonymous , not very clear

column =divide(countx(filter(Table, [source] =earlier([source]) && table[orderstatus]= "Filled"),[OrderID]),countx(filter(Table, [source] =earlier([source])),[OrderID]))

measure =

divide(calculate(count(Table[OrderID]), table[orderstatus]= "Filled"),count(Table[OrderID]))

[Greg_Deckler]

@Anonymous - I believe you want one of these. PBIX is attached.

Column 1 = 
    VAR __All = COUNTROWS(FILTER('Table (26)',[source]=EARLIER([source])))
    VAR __Count = COUNTROWS(FILTER('Table (26)',[source]=EARLIER([source]) && [orderstatus]="Filled"))
RETURN
    IF(ISBLANK(__Count),0,__Count/__All)


Column = 
    VAR __All = COUNTROWS('Table (26)')
    VAR __Count = COUNTROWS(FILTER('Table (26)',[source]=EARLIER([source]) && [orderstatus]="Filled"))
RETURN
    IF(ISBLANK(__Count),0,__Count/__All)

[Anonymous]

@Greg_Deckler  

thanks Greg,  This works funtastic. However, its not working in my actual data.  

For example, Amrutha total count of orders is 64162 and filled is 18203. So the fill rate should be 18203/64162 = 28.37%.

But i m getting, 55.44%

Am i missing anything?

below is how i modified your formula.

column111 = divide(countx(filter(Query1, Query1[source_system] =earlier(Query1[source_system]) && Query1[orderstatus]= "Filled"),[order_id]),countx(filter(Query1, Query1[source_system]=earlier(Query1[source_system])),[order_id]))

[Greg_Deckler]

@Anonymous Can you share PBIX?