Get the number of item based on multiple column

[pigip]

Hello, PowerBI Guru , I have a table as below, I would like to make a DAX to calculate how many component’s pass ratio ([Pass Test]/[Total Amount]) is more than 95%. I need to get the result per YEAR, YEAR MONTH.  Thanks in advance !

Component	Test Date	Total Amount	Pass Test
A	25/11/2019	100	99
B	27/11/2019	200	198
A	14/12/2019	120	116
B	15/12/2019	100	97
C	16/12/2019	150	120

[v-jayw-msft]

Hi @pigip ,

Create measures and visual as below.

percentage = SUM('Table'[Pass Test])/SUM('Table'[Total Amount])
pass95 = CALCULATE(DISTINCTCOUNT('Table'[Component]),FILTER('Table',[percentage]>0.95))

 

Best Regards,

Jay

[pigip]

Big thanks ! It also works very well !

[Ashish_Mathur · Accepted solution]

Hello

You can download my PBI file from here.

I hope this helps.

[pigip]

Thanks for prompt response. It works

[pranit828]

HI @pigip 

I have created three columns as below.

Year = YEAR([Test Date])

Month = MONTH([Test Date])

Pass_95 = IF(DIVIDE([Pass Test],[Total Amount],0)*100>95,1,0)

and use these columns for the visual