Card value as percent of total

[Anonymous]

Hi all, 

I have a dataset with product codes like below:

Product Codes

A119

A232

A236

B180

P504

I want to create a card that shows the count of product codes that begin with "A" as a percent of the total number of product codes (in this example, the answer would be 60%). I figure I should create a new measure, but nothing I've written up has worked. 

Thanks in advance & let me know if you need any more info!

[Ashish_Mathur · Accepted solution]

Hi,

This measure works

=COUNTROWS(FILTER(VALUES(Data[Product Codes]),LEFT([Product Codes],1)="A"))/COUNTROWS(Data)

Hope this helps.