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
If it helps... my spreadsheet/datasource is something like this:
Column A = Inspection number (unique identifier, no repeating)Column B = DateColumn 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.
Go to 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,
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)
@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,
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.