Calculate Percent Progress using Multiple Filter in Denominator

[Anonymous]

Hello.
Good evening.
I would like to ask for you assistance.
I am a Newbie here, and I'm struggling to get the percentage progress.

This data is not related to each other. 
Currently, what I did is 

Pipeline Progress per Unit No = Divide(Numerator, Denominator)
whereas;
Numerator = DistinctCount('S3D_REPORT'[Line ID Modelled in S3D)
Denominator = CountX(Filter('LineList_Data',Linelist'_Data [Unit No] = "01"), Linelist_Data [Unit No])

My problem is how to filter the other Unit.
And also, I would like to ask for an Alternate Result if there's no unit selected.

Thank you. 

[Anonymous · Accepted solution]

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.

[amitchandak]

@Anonymous , not very clear. but isfiltered can help

refer: https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.