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