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 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.
 

 

 

 

1 Reply

  • 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