Forum Discussion

proavinash's avatar
proavinash
Helper I
1 year ago

Smart Narrative Report not update values

When using NO'LEADS'NCR its works perfectly, as in screen shot.   When using NO'LEADS'GUJARAT  & NO'LEADS'MUMBAI its works perfectly, as in screen shot.   BUT when i use other then th...
jaineshp's avatar
jaineshp
Memorable Member
1 year ago

Hey proavinash,

Based on your screenshots and description, here's a systematic solution for your Smart Narrative dynamic value issue:

Problem Analysis

  • Smart Narrative is recognizing some zone-based measures (NCR, GUJARAT, MUMBAI) but failing to display others (KTK, AP, etc.) despite DAX formulas working correctly
  • All measures follow identical syntax structure
  • Results show properly in DAX but not in Smart Narrative interface

Solution Steps

1. Verify Zone Name Consistency

  • Check exact spelling and case sensitivity in your Zone column
  • Compare working zones (NCR, GUJARAT, MUMBAI) with non-working ones (KTK, AP)
  • Look for hidden spaces, special characters, or formatting differences

2. Validate Data Availability

  • Confirm that KTK and AP zones actually contain data in your current filter context
  • Test individual measures in a simple table visual first
  • Verify [No Leads from Stores 2025] has non-zero values for these zones

3. Smart Narrative Refresh Process

  • After creating/modifying measures, refresh the Smart Narrative visual completely
  • Remove and re-add the Smart Narrative visual to force recognition of new measures
  • Check if measure names appear in the dynamic value dropdown list

4. Measure Optimization

  • Simplify your DAX syntax using this cleaner approach:

NO'LEADS'KTK = CALCULATE(SUM(Kohler_Studio[No Leads from Stores 2025]), Kohler_Studio[Zone] = "KTK")

5. Alternative Approach

  • Create a single parameterized measure instead of multiple zone-specific measures
  • Use a slicer or parameter to control zone selection
  • This reduces complexity and improves Smart Narrative compatibility

6. Troubleshooting Steps

  • Test measures in Card visuals to confirm they work outside Smart Narrative
  • Check Power BI service vs Desktop behavior differences
  • Verify your data model relationships are properly established

The issue likely stems from data inconsistencies in the Zone column rather than DAX formula problems.

Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

Best regards,
Jainesh Poojara / Power BI Developer