cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sabeensp Helper IV
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.

 

Appreciate your help.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User I
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

image.png



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

Proud to be a Datanaut !





View solution in original post

Community Support
Community Support

Re: Percent of Column

4 REPLIES 4
Super User I
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])

image.pngimage.png

 

image.png



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

Proud to be a Datanaut !





sabeensp Helper IV
Helper IV

Re: Percent of Column

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

Super User I
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

image.png



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

Proud to be a Datanaut !





View solution in original post

Community Support
Community Support

Re: Percent of Column

Helpful resources

Announcements
New Ranks Launched March 24th!

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!

‘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

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.

Top Solution Authors
Top Kudoed Authors