You are asked to compare two metrics that are logically incompatible. How do you respond?

< 1 min read

First, I would review the definitions of both metrics to understand why they are logically incompatible.
Often the issue comes from differences in calculation logic, time period, or data source.
I would explain these differences clearly to the stakeholder.
For example, comparing a monthly aggregated metric with a daily operational metric may lead to incorrect conclusions.
In one project, a team wanted to compare total revenue with number of active users without considering the time window.
I explained that the metrics measured different aspects of performance.
Instead, I suggested using a compatible metric such as revenue per active user.
This allowed a meaningful comparison while maintaining analytical accuracy.
Finally, I would document the metric definitions to prevent similar confusion in the future.

Power BI Essentials