Percent of Column

[sabeensp]

Hello,

Being new to PBI, it is hard for me but maybe not for you.

I need to find out % of total.

In one table I have Customers and Transactions

Cust ------- Transaction
A                 1

B                 1
C                1

D                1

A                1

A                1

I've created a meesure COUNT(Transactions) which comes to 6
I have a filter, which allows user to select Cust.

I need to find out the % of Transactions by selected Cust. so If user select CUST A the 3/6 and etc.

Appreciate your help.

[PattemManohar · Accepted solution]

@sabeensp Oh ok !! Then, update the measure logic as below (And Don't use "show value as" option for this)

Test120 = 
VAR _Total = CALCULATE(SUM(Test120Measure[Trans]),ALL(Test120Measure))
VAR _CustTotal = SUM(Test120Measure[Trans])/_Total
return _CustTotal

[v-chuncz-msft · Accepted solution]

@sabeensp,

Here are some exmaples.

• https://community.powerbi.com/t5/Desktop/Filter-for-Card-Visual-does-not-work-of-GT/m-p/437473#M2018...
• https://community.powerbi.com/t5/Desktop/Percentages-to-multi-line-report/m-p/378504#M172040
• https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139

[PattemManohar]

@sabeensp You just create a measure with total as below and then use the option "Show value as "

Test120 = SUM(Test120Measure[Trans])

[sabeensp]

I tried that, but when I select cutomer from the filter, it shows 100%.

[PattemManohar · Accepted solution]

@sabeensp Oh ok !! Then, update the measure logic as below (And Don't use "show value as" option for this)

Test120 = 
VAR _Total = CALCULATE(SUM(Test120Measure[Trans]),ALL(Test120Measure))
VAR _CustTotal = SUM(Test120Measure[Trans])/_Total
return _CustTotal