Translate a question into metrics
Start with a decision, not a dashboard layout. Use a fictional student society that wants to understand event registrations and attendance.
Break it down
01Build it yourself
Write the decisions the dashboard should support. Define registrations, attendees and attendance rate, including the reporting period, treatment of cancellations and denominator. List where each field comes from and who owns its definition.
02Ready to move on?
Two people following your metric dictionary would calculate the same result. Explain the difference between a count, a rate and a target, and what happens when a denominator is zero.
Take it further
Continue learning on these source websites.
Microsoft Learn: Power BI training(opens in a new tab)