🔥 3-day streak
Microsoft Power BI Data Analyst67 / 205
Question 67 of 205
You are building a semantic model for a retail company. A stakeholder asks for a Profit Margin % measure calculated as total profit divided by total sales. Some product categories have zero sales in certain months, and the report currently shows Infinity or error values in those cells. You must create a measure that returns a blank value instead of an error when the denominator is zero. Which DAX expression should you use?
Reviewed for accuracy · Report an issueNext question