need help in DAX query with COUNTA, DISTINCT, and FILTER

[brokiga]

Need help to calculate number of NG product from below chart.

I tried DAX query but could not visualize the data in report view.

=COUNTA(DISTINCT(FILTER('Raw Data','Raw Data'[Product]&&'Raw Data'[OK/NG]="NG")))

•  

 

[jgeddes · Accepted solution]

This should work for you.

Measure = 
CALCULATE(
    DISTINCTCOUNT(sampleTable[Product]),
    FILTER(sampleTable, sampleTable[OK/NG] = "NG")
)