How to use Dax to calculate count of good supplier
I have a table as below. What I want is to set up a date slicer, when I choose a date range, Power BI can automatically show the count of good suppliers. This is dynamic, and my initial idea is to create a new measure, but I cannot figure out, wish someone can give me some idea.
Rate = (sum[A]+sum[B])/(sum[A]+sum[B]+sum[C])
Condition for good supplier is rate >80%.
For example, when date is set from 2020/9/21 to 2021/10/15, count of good suppliers is 2 (SUPPLIER_NO 4 has rate lower than 80%)