Forum Discussion
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
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,
3 Replies
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,Anonymous
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,
