smart narrative producing no results, but same measure works in table or card

scabral — Wed, 09 Nov 2022 18:53:11 GMT

I have the following measure that will return either Low, Medium or High from a column in a table:

VAR CountRange =

SWITCH(

TRUE(),

[Account Selection Count] >= 3 && [Account Selection Count] <= 8, "3-8",

[Account Selection Count] >= 9 && [Account Selection Count] <= 12, "9-12",

[Account Selection Count] >= 13, "13+",

BLANK()

)

VAR AcctConfidenceRating =

CALCULATE(

MIN('Confidence Rating'[Confidence Rating]),

TREATAS({(CountRange, [Renewal Interval Match])}, 'Confidence Rating'[Count Range], 'Confidence Rating'[Renewal Interval Match])

)

Return

AcctConfidenceRating

If I use this measure in a card or table it works fine, but when i add it to a text box as a smart narrative it is blank and gives me the following message:

current data and filters produce no result for this value.

Thanks

scott

Re: smart narrative producing no results, but same measure works in table or card

v-jialluo-msft — Thu, 10 Nov 2022 07:06:33 GMT

^{Hi scabral ,}

^{This issue may be due to triggering some limitations of smart narrative, so check out the limitations:}

Smart narratives tutorial - Power BI | Microsoft Learn

^{If not for this reason, please provide specific example files to further troubleshoot the cause of the question}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

topic Re: smart narrative producing no results, but same measure works in table or card in DAX Commands and Tips

smart narrative producing no results, but same measure works in table or card

Re: smart narrative producing no results, but same measure works in table or card