Forum Discussion

GanesaMoorthyGM's avatar
GanesaMoorthyGM
Icon for Helper II rankHelper II
1 year ago
Solved

Unusual Data Mismatch

Hii Guys, So Today I was working in Sales and Target report and Unusual mismatch occurs, let me explain So i have Cluster Dim which models with fact sales and Cluster Target Cluster DIM has C...
Need Help
Show and Tell
Tips and Tricks
  • v-achippa's avatar
    v-achippa
    11 months ago

    Hi GanesaMoorthyGM,

     

    Is you issue resolved? If not please follow the below approach.

     

    Here the mismatch happens because your current measure calculates the last sales date in a cluster filtered context. So in the cluster dim visual this cuts off early, so you only see 0.25.
    To fix it, please use the below measure:

     

    Oman YTD Target =
    VAR LastSalesDate = CALCULATE(
    MAX('Fact_Sales_Master'[DateOnly]),
    ALL('Fact_Sales_Master'),
    'Fact_Sales_Master'[Country] = "Oman"
    )

     

    This way both visuals will consistently return 0.39 for Gold_Coins, matching your excel result.

     

    Thanks and regards,

    Anjan Kumar Chippa

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

The mismatch (0.25 in Power BI vs 0.39 in Excel for Gold_Coins in Oman) is likely due to one of these:
- Filter context: Power BI might be filtering Oman differently.
- Stale data: Excel was updated but Power BI wasn’t refreshed.
- Mapping issue: Gold_Coins might not be mapped correctly in Cluster DIM.
- DAX logic: Your measure might exclude some rows unintentionally.
Start by checking filters, refreshing data, and validating mappings.