Smart Narrative DAX Bug - Measure Not Returned

[ebeery]

This appears to be a bug in the DAX generated by Smart Narratives (within a text box).

Measure displays properly when in a Card visual, but not in Smart Narrative. 

See minimally-reproduced sample .pbix attached.

Table = 
{ ( 1, "A" ), ( 2, "A" ), ( 3, "B" ), ( 4, "B" ), ( 5, "C" ), ( 6, "C" ) }

Value1Value2

1	A
2	A
3	B
4	B
5	C
6	C

SelectedValue2 = SELECTEDVALUE('Table'[Value2])

SelectedValue2_Switch = 
VAR _CountValue2s =
    COUNTROWS ( VALUES ( 'Table'[Value2] ) )
VAR _Result =
    SWITCH (
        TRUE (),
        _CountValue2s = 1, SELECTEDVALUE ( 'Table'[Value2] ),
        _CountValue2s > 1, "Multiple",
        _CountValue2s = 0, BLANK ()
    )
RETURN
    _Result

Smart Narrative Bug - Repro.pbix

[Anonymous]

Hi @ebeery ,

This issue has been submitted internally with ICM 295304333

Problem description: 

Measure displays properly when in a Card visual, but not in Smart Narrative.

The product team will be investigating this issue and once any updates are available, I will sync the information for you here.

Best Regards,
Community Support Team _ Caitlyn

[Anonymous]

@Anonymous  Is there a recent update that addresses this issue? I'm having the same problem and can't refer to any measures or calculated columns using DAX through the smart narrative. 

[Anonymous]

Hi @Anonymous ,

Smart Narrative uses semantic queries. This known limitation cannot be resolved at this time.

Best Regards,
Community Support Team _ Caitlyn