Count number of groups with at least one value

[bubblepop]

I have a table that looks like this:

Product Name | Subproduct Name | Subsubproduct name | IsVerified

A | B | C | True

A | B | D | 

A | B | E | 

X | Y | Z | True

X | Y | Q | True

W | P | R | 

W | V | T |

I want to count the (number of products with at least one True in its corresponding row) / (distinct number of products). The expected answer for the table above is 2/3. 2 because product A and X both have at least one True in their last column. 3 because there are three distinct products, A, X, and W.

I can compute the denominator with DISTINCTCOUNT(Product Name) but I need help with the numerator. My initial attempt was to do a groupby over the Product Name, but I don't know how to extract just 1 True value. 

[ChrisMendoza · Accepted solution]

Try :

Numerator Measure = 
CALCULATE (
    DISTINCTCOUNT ( TableName[Product Name] ),
    TableName[isVerified] = TRUE ()
)

Measure = DIVIDE([Numerator Measure],[Denominator Measure],0)