Forum Discussion

PBR_'s avatar
PBR_
Frequent Visitor
3 years ago
Solved

PowerBI Dax Fill Rate Percentage

I'm trying to get a fill rate (%) formula that calculates the fill rate based on entry Status, and is dynamic (i.e., the calculation will update depending on what filters are selected within PowerBI,...
Need Help
  • barritown's avatar
    barritown
    3 years ago

    PBR_, like this? 

    Rate = 
VAR _unfill = COUNTX ( FILTER ( data, LEFT( [Status], 6 ) = "Unfill" ), [Status] )
VAR _fill = COUNTX ( FILTER ( data, LEFT( [Status], 4 ) = "Fill" ), [Status] )
RETURN DIVIDE ( _fill, _unfill )

    Best Regards,

    Alexander

    My YouTube vlog in English

    My YouTube vlog in Russian

barritown's avatar
barritown
Icon for Solution Sage rankSolution Sage
3 years ago

PBR_, like this? 

Rate = 
VAR _unfill = COUNTX ( FILTER ( data, LEFT( [Status], 6 ) = "Unfill" ), [Status] )
VAR _fill = COUNTX ( FILTER ( data, LEFT( [Status], 4 ) = "Fill" ), [Status] )
RETURN DIVIDE ( _fill, _unfill )

Best Regards,

Alexander

My YouTube vlog in English

My YouTube vlog in Russian

PBR_'s avatar
PBR_
Frequent Visitor
3 years ago

Thanks, Alexander! 

I slightly modified it to this and it seems to be working well, including when applying slices/filters.

Rate = 
VAR _unfill = COUNTX ( FILTER ( data, LEFT( [Status], 6 ) = "Unfill" ), [Status] )
VAR _fill = COUNTX ( FILTER ( data, LEFT( [Status], 4 ) = "Fill" ), [Status] )
RETURN DIVIDE ( _fill, (_unfill+_fill) )

Thank you for your help!