Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! 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,
@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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |