Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
There appears to be a bug with using Measures in Smart Narratives and the mere existence of a calculation group.
There are two calculation items in the Sales Doubler calc group, one is SELECTEDMEASURE() and the other is SELECTEDMEASURE() * 2.
The calculation group is not applied in this mode. It just exists. If I change the Sales Doubler item to just SELECTEDMEASURE() as well, the smart narrative works, but if it is anything except SELECTEDMEASURE() it returns blank, even though the card works.
I know that by applying the CG will cause an error because you cannot multiply text * 2, but that isn't the issue. I can control that with ISSELECTEDMEASURE() or by using the CG in a slicer then editing the interactions to exclude the card and Smart Narrative, but I cannot even get that far. Doing that does not restore the smart narrative.
This seems to be a relatively new issue. I do not recall seeing this in the past few months, and I make extensive use of measures in Smart Narratives to return the text I want.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.