Calculate Percent Progress using Multiple Filter in Denominator

Hi Anonymous 

Please correct me if I wrongly understood your question.

Maybe you can consider using ‘Linelist_Data’[Unit No] as a slicer . So you don’t need to specify the value of ‘Linelist_Data’[Unit No] in the formula .

Then create a measure to count the ‘Linelist_Data’[Unit No].

Denominator = COUNTX(LineList_Data,SELECTEDVALUE(LineList_Data[unit No]))

The effect is as shown

If you do not filter in the slicer, the return value is the count of all non-empty results in the column .

Best Regards

Community Support Team _ Ailsa Tao

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