Data not coming in Azure Map but in Map Visual

Hey Surekha_PM ,

Based on your issue description and the screenshots provided, here's a comprehensive analysis and solution for the Azure Map vs Map Visual data discrepancy:

Key points to focus on for immediate resolution:

1. Replace REMOVEFILTERS with ALL() - Azure Map has better compatibility with ALL() functions
2. Simplify the measure structure - Break down complex calculations into smaller, manageable components
3. Use DIVIDE() function - This handles zero division scenarios more reliably
4. Verify geographic data binding - Ensure location fields are properly mapped in Azure Map

The step-by-step implementation guide should help you resolve this issue systematically while maintaining data accuracy across both visual types.

// Alternative Version with more explicit error handling
VAR PPB =
IF(
ISBLANK(CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))),
0,
CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))
)

VAR PPCOMP =
IF(
ISBLANK(CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 1, Table_V3[RowID] <> BLANK(), ALL(B[BOnly]), ALL(B[SubB]))),
0,
CALCULATE(SUM(Table_V3[PPCount]), Table_V3[IsCom] = 1, Table_V3[RowID] <> BLANK(), ALL(B[BOnly]), ALL(B[SubB]))
)

VAR BProd =
IF(
ISBLANK(CALCULATE(SUM(Table_V3[OrgCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))),
0,
CALCULATE(SUM(Table_V3[OrgCount]), Table_V3[IsCom] = 0, Table_V3[RowID] <> BLANK(), ALL(Comp[ComOnly]), ALL(Comp[SubB]))
)

VAR TotalPP = PPB + PPCOMP

RETURN
IF(TotalPP = 0, 0, BProd / TotalPP)

Testing Steps:

1. Apply the first modified version in your Azure Map
2. Test with the same filters (Comp[ComOnly] and Comp[SubB])
3. If issues persist, try the alternative version
4. Compare results with your working Map Visual to ensure accuracy

The primary modification (replacing REMOVEFILTERS with ALL) should resolve the Azure Map data display issue while maintaining the same calculation logic.

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

Best regards,
Jainesh Poojara / Power BI Developer