Your Power BI data model already contains dozens of numeric measures such as Total Sales, Total Cost, and Margin. You need to implement a Currency Conversion calculation group in Tabular Editor so that any current or future measure can be converted without creating duplicate measures. In the calculation item expression, which DAX function must you use to return the value of whatever measure is currently in context before multiplying it by the appropriate exchange rate?
Calculation items should be written generically so they can operate on any measure that the user has placed in a visual. The DAX function SELECTEDMEASURE() returns the result of the measure that is currently being evaluated, allowing you to reuse the same expression across multiple measures. Other functions such as SELECTEDVALUE(), CALCULATE(), or a fictitious CURRENTMEASURE() either retrieve a single column value, change filter context, or simply do not exist, so they cannot serve this purpose.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is SELECTEDMEASURE() in Power BI DAX?
Open an interactive chat with Bash
How do calculation groups improve efficiency in Power BI?
Open an interactive chat with Bash
Why can't functions like SELECTEDVALUE() or CALCULATE() replace SELECTEDMEASURE()?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Model the Data
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .