Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have attached a PBIX illustrating the issue.
The issue:
Under certain conditions, measures that return a text value will return incorrect results when a calculation group exists in the model (even if the calculation group is not applied).
Sample PBIX:
The problem measure is Stars UNICHAR 11088 (error).
The measure definition is:
Stars UNICHAR 11088 (error) =
VAR SingleStar =
UNICHAR ( 11088 ) -- Star character 11088 "⭐"
VAR NumStars =
[Selected Company]
VAR Result =
REPT ( SingleStar, NumStars )
RETURN
Result
This measure is intended to return a text value containing Unicode character 11088 repeated [Selected Company] times, where
Selected Company =
SELECTEDVALUE ( Company[Company ID] )
The model includes a calculation group with a single calculation item with expression
SELECTEDVALUE () & ""
This calculation group is not applied in the report, however.
Behaviour:
Conditions that appear produce this behaviour:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @OwenAuger
You can put your issue to Ideas Forum , if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Ideas (powerbi.com)
Best Regards,
Community Support Team _ Ailsa Tao