Reply
Topic Options
- 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
Formula/Calculation help
06-09-2023
09:22 AM
CalcName = DIVIDE(CALCULATE(COUNTROWS('List1), 'List1'[Cert] = "Training1" && 'List1'[Section] == "HR"), DISTINCTCOUNT(Roster[ID])) * 100
I am using this formula to calculate the individual percentages of trainings complete within PowerBI. Is there anyway to write this as a general formula, and not have it for each individual training? As it currently stands I have 20 of these same calculations and I'm sure there is a way to write this formula one time and display it to my graph.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
09:40 AM
Hi @3cdoug
just place 'List'[Cert] in a table visual and place the same measure after deleting the relevant filter
CalcName =
DIVIDE (
CALCULATE ( COUNTROWS ( 'List1' ), 'List1'[Section] = "HR" ),
DISTINCTCOUNT ( Roster[ID] )
) * 100
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023
09:40 AM
Hi @3cdoug
just place 'List'[Cert] in a table visual and place the same measure after deleting the relevant filter
CalcName =
DIVIDE (
CALCULATE ( COUNTROWS ( 'List1' ), 'List1'[Section] = "HR" ),
DISTINCTCOUNT ( Roster[ID] )
) * 100

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-21-2025 02:04 PM | |||
06-09-2025 06:10 AM | |||
08-06-2024 03:07 PM | |||
06-16-2025 01:57 PM | |||
Anonymous
| 12-21-2022 03:51 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
23 | |
9 | |
7 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
28 | |
11 | |
11 | |
10 | |
6 |