cancel
Showing results for
Did you mean:
Highlighted
Helper IV

## Percent of Column

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.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I

## Re: Percent of Column

@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```

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Community Support

## Re: Percent of Column

Here are some exmaples.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User I

## Re: Percent of Column

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

`Test120 = SUM(Test120Measure[Trans])`

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Helper IV

## Re: Percent of Column

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

Super User I

## Re: Percent of Column

@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```

Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !

Community Support

## Re: Percent of Column

Here are some exmaples.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors