Forum Discussion
Unusual Data Mismatch
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
Thanks for uour quick response jaineshp ,
I already tried this
Double-check if Gold_Coins exists with duplicates or small spelling/space differences across DIM and Target.
Make sure the relationship between Cluster DIM → Target is 1-to-many, single direction.
But still not fixed
Hi GanesaMoorthyGM,
Thank you for reaching out to Microsoft Fabric Community.
Thank you jaineshp, Shahid12523 and danextian for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
Hello GanesaMoorthyGM, the comment you are responding to has been removed.
Best,
Natalie H.
Community Manager
