Forum Discussion
Solved
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 wit...
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,