Forum Discussion
Calculate Percentage
Hi all,
Apologies for the delayed reply—I've been flat out with work.
Thank you again for looking into my question. While I appreciate the suggested solutions, they didn’t quite meet my requirements. I ended up creating another visual to show the overall YTD percentage.
Thanks again for your support.
Best regards,
Vince
Hi vincenttys ,
Thanks for reaching out to the Microsoft fabric community forum.
Use the following measure:
% Delivered =
VAR DeliveredCount = SUM('YourTable'[Delivered])
VAR TotalWeeks = CALCULATE(DISTINCTCOUNT('YourTable'[WeekEnd]), REMOVEFILTERS('YourTable'[Vendor]))
VAR Result = DIVIDE(DeliveredCount, TotalWeeks)
RETURN
IF(
ISINSCOPE('YourTable'[Vendor]),
Result,
BLANK()
)
Take a Matrix visual and add following fields:
- Rows: Vendor
- Values: % Delivered (Only this measure)
- Go to the Fields pane on the right side.
- Click on the %Delivered measure. Set the Data Type to Decimal Number (if it's not already), and then set Format to Percentage with 1 decimal place, for example.
Please go through the screenshot and document for more information:
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Hi v-menakakota
Thanks for getting back to me so quickly.
My table would have week ending on the columns pane.
I hope that makes sense—please let me know if you need clarification.
Thank you
Hi vincenttys ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Thank youHi vincenttys ,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.Hi vincenttys ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.