cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abeiswinger Regular Visitor
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:Inspection Percentages 1.png

What Power BI does:

Inspection Percentages 2.png

 

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 v-yuezhe-msft
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.
1.JPG


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 v-yuezhe-msft
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.
1.JPG


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.
abeiswinger Regular Visitor
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 v-yuezhe-msft
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.

Helpful resources

Announcements
Virtual Launch Event

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

Power BI Helps Homeless and Trouble Youth

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 126 members 1,986 guests
Please welcome our newest community members: