Forum Discussion
kaarel
Resolver I
10 years agoSCOPE() format_string problem SSAS live
Hi! I think I found a bug. I've got 2 measures with 2 different format strings. "Margin" with #,##0 and "Margin SEK" with #,##0'kr'. The latter represents Swedish currency. In the scrip...
sergezai
10 years agoNew Member
I have a similar problem with scope() and formatting values in PowerBI. I found that any scope statement in SSAS cube actually screws up the formatting of any measure defined before the scope statement. Microsoft confirmed that it's a bug in Power BI but they didn't provide any further details when it's gonna be fixed.
- kaarel10 years ago
Resolver I
Hopefully soon...
- S-Driancourt9 years agoFrequent Visitor
I had a simular issue, and thanks to your post I was able to solve my problem, by putting all the scopes before the creation of the calculated members.
- kaarel9 years ago
Resolver I
Chris Webb recently blogged about this:
https://blog.crossjoin.co.uk/2017/04/18/power-bi-ssas-multidimensional-and-dynamic-format-strings/