cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Use Quick Measure to show Percentage by Column?

When I use "show percentage" option, it shows overall instead of by month.  Can I use Quick Measure to show the percentage of "On-Time" data out of the total of On-Time + Past Target?

My data with counts of Inspections:

What Power BI does:

But I want it to say January = 79%, February =84%, etc.

January = 30/38

February = 38/45

etc.

If it helps... my spreadsheet/datasource is something like this:

Column A = Inspection number (unique identifier, no repeating)
Column B = Date
Column C = On-Time or Past Target

I'm okay with removing "Past Target" and leaving it as blank, if that helps with a Quick Measure to count the On-Time out of the total... I just don't know which one to use.

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Use Quick Measure to show Percentage by Column?

@abeiswinger,

Right-click your table and select “New measure” to create the following measure in your tables.

Total = SUM(Table[Column A])
On-Time total = CALCULATE(SUM(Table[Column A]),FILTER(Table, Table[Column C]="On-Time"))
percent = [On-Time total]/[Total]

Then create line chart as follows.

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Moderator

## Re: Use Quick Measure to show Percentage by Column?

@abeiswinger,

Right-click your table and select “New measure” to create the following measure in your tables.

Total = SUM(Table[Column A])
On-Time total = CALCULATE(SUM(Table[Column A]),FILTER(Table, Table[Column C]="On-Time"))
percent = [On-Time total]/[Total]

Then create line chart as follows.

Regards,

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

## Re: Use Quick Measure to show Percentage by Column?

@v-yuezhe-msft

I receive an error that says "The syntax for "On" is incorrect.  Whatever I put instead of "On-Time Total" gives the same mesage (the syntax for ____ is incorrect)

Moderator

## Re: Use Quick Measure to show Percentage by Column?

@abeiswinger,

Please share sample data of your table, and post the screenshot of your scenario. And you can check my DAX in the attached PBIX file.

Regards,

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

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 126 members 1,986 guests
Recent signins: