Smart Narrative Report not update values

proavinash — Wed, 30 Jul 2025 16:34:20 GMT

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.

Re: Smart Narrative Report not update values

jaineshp — Thu, 31 Jul 2025 06:27:21 GMT

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

topic Re: Smart Narrative Report not update values in Custom Visuals Development Discussion