Use Quick Measure to show Percentage by Column?

[abeiswinger]

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

[v-yuezhe-msft · Accepted solution]

@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,

[abeiswinger]

@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)

[v-yuezhe-msft]

@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,