Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Smart Narrative DAX Bug - Measure Not Returned

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

 

ebeery_2-1647282796290.png

 

ebeery_3-1647282869401.png

 

ebeery_4-1647282879661.png

 

Status: Accepted

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Accepted

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

sstewarta
Frequent Visitor

@v-xiaoyan-msft  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. 

v-xiaoyan-msft
Community Support

Hi @sstewarta ,

 

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

 

 


Best Regards,
Community Support Team _ Caitlyn