Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
// Not sure if I've got the logic right as I can't see
// the model. Also, not sure if all the language
// constructs will work in the DQ mode.
[Base Value] = SUM( 'Table'[Value] )
[Value Converted] =
VAR SelectedCurrency =
// This line says: if there is only one visible Code
// in the current context, take it. Otherwise use "USD".
COALESCE( SELECTEDVALUE( Results_ExchangeRates[Code] ), "USD" )
// This will return the rate if there's only one visible
// in the current context. If none is visible or many, BLANK
// will be returned.
VAR SelectedRate = SELECTEDVALUE( Results_ExchangeRates[Rate] )
VAR EffectiveRate =
// For code = "USD", return rate = 1, else take
// the rate from above.
IF( SelectedCurrency = "USD", 1, SelectedRate )
VAR Result = [Base Value] * EffectiveRate
RETURN
Result
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
9 | |
7 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |