Hi,
Dynamic threshold is available only for Metric Alerts and it is not available for Log Alerts. If you want to take advantage of Metric alerts and dynamic threshold you need to use the custom metrics integration in Azure Monitor which allows you to send metrics to the same store where Azure resources store their metrics. Custom metrics are charged separately.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.