- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Percentage Calculation
Hi - I tried to search but could not find the exact answer for this simple one - this is a matrix report filtered just to show 2023 deals by lead source.
I'd like to add a coulmn that shows the % that each lead source makes up of the total leads.
Is this snip enough for folks to go on?! Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Rupe ,
Create a new measure.
count of id =
var _a=SELECTEDVALUE('Table'[LeadSource(groups)])
var tmp=FILTER(ALL('Table'),[LeadSource(groups)]=_a)
var _ctn=COUNTROWS(tmp)
var _b=COUNTROWS(ALL('Table'))
return IF(HASONEVALUE('Table'[LeadSource(groups)]),_ctn,_b)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks will give that one a shot.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @v-tangjie-msft - thanks for the reply. So the formula runs, but not sure its giving the correct result?
I pointed the DAX to the Opportunity table where the records sit:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Rupe ,
Create a new measure.
count of id =
var _a=SELECTEDVALUE('Table'[LeadSource(groups)])
var tmp=FILTER(ALL('Table'),[LeadSource(groups)]=_a)
var _ctn=COUNTROWS(tmp)
var _b=COUNTROWS(ALL('Table'))
return IF(HASONEVALUE('Table'[LeadSource(groups)]),_ctn,_b)
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Rupe ,
According to your description, here are my steps you can follow as a solution.
(1) This is my test data.
(2) We can create a measure.
% of Total =
var _a=SELECTEDVALUE('Table'[LeadSource(groups)])
var tmp=FILTER(ALL('Table'),[LeadSource(groups)]=_a)
var _ctn=COUNTROWS(tmp)
var _b=COUNTROWS(ALL('Table'))
return
IF(HASONEVALUE('Table'[2023Type]),BLANK(),
IF(HASONEVALUE('Table'[LeadSource(groups)]),DIVIDE(_ctn,_b),1))
(3) Then the result is as follows.
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-05-2025 03:44 AM | |||
10-24-2024 03:14 AM | |||
11-26-2024 12:57 AM | |||
02-11-2025 06:10 AM | |||
10-24-2024 03:49 PM |
User | Count |
---|---|
90 | |
82 | |
57 | |
41 | |
39 |