- 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
Trying to create a percentage based on two different fields depending on which model, how many returns processed / total units produced. I made some attempts that did not work but the very basic idea of what I need would be Formula count / total produced. The measure for Formula Count is shown in the picture. I also know that some Total Produced values are blank. I am pretty new to Power BI so hopefully this isn't something too obvious. The reason it has not worked for me so far is that there are multiple values where PowerBI expects one value to be present (the Total Produced column).
ced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think this can help.
Always use "/Calculate AllSelected" to get percentages, for me is the best way.
and the "if isblank" fixes the problem with lines without values.
Percentage = if( Isblank(
Counta(AviationTable[Unit Description])) ;0 ;Counta(AviationTable[Unit Description]) /CALCULATE(Counta(AviationTable[Unit Description]);AllSelected())
I Hope to have helped
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Im not an expert at all, but did you try:
Percentage = [Formula Count] / [Total Produced]
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 - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
10-07-2024 02:16 PM | |||
11-26-2024 12:57 AM | |||
10-24-2024 03:14 AM | |||
10-24-2024 03:49 PM | |||
09-04-2024 02:21 AM |
User | Count |
---|---|
13 | |
13 | |
12 | |
8 | |
7 |
User | Count |
---|---|
18 | |
14 | |
11 | |
11 | |
9 |