Percent by Customer

[sabeensp]

I have a very simple report which has a drop down filetr on Customer. I need to find out % of transaction of selected customer 
Table has Customers and Transactions

Cust ------- Transaction
A                 1

B                 1
C                1

D                1

A                1

A                1

I've created a measure COUNT(Transactions) which comes to 6 

I need to find out the % of Transactions by selected Cust. so If user select CUST A the 3/6 = 50% , if user selects B 1/6 = 16%, if none selected then 100%

Appreciate your help.

[v-yulgu-msft · Accepted solution]

Hi @sabeensp,

You can new a measure:

Measure percentage =
COUNT ( 'Customertabble'[Transaction] )
    / CALCULATE ( COUNT ( 'Customertable'[Transaction] ), ALL ( 'Customertable' ) )

Best regards,

Yuliana Gu

[sabeensp]

Thanks