Forum Discussion
Calculate Percent Progress using Multiple Filter in Denominator
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.
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.
2 Replies
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.
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.
