Smart Narrative Report not update values

[proavinash]

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 these , like NO'LEADS'KTK  ,  NO'LEADS'AP AND OTHER Its not work, no result come out as screen shot.

FORMULA USED FOR OUTCOME

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

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

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

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

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

although result of all come from dax formula but not all come in smart narrative report as screen shot.

[jaineshp]

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