Modelling issue causing measure not properly working

Hi Hansolu,

After thoroughly reviewing the details you provided, I was able to reproduce the scenario, and it worked on my end. I have used the sample data on my end and successfully implemented it.  

I am also including .pbix file for your better understanding, please have a look into it:

Hope this will help you resolve your issue, if you need any further assistance, feel free to reach out.

Thank you for using Microsoft Community Forum.

Hi, 

first, sorry for my late reply, was too busy and could not look into.

second, the conversation and the file from v-sgandrathim made me think another way.

Now, in the batch table I created a colum FROM and TO with Merge and index. Now I know when was the start and end of the batch.

Then I go to the create a new table , fact_machine_batches, and merge the corresponding batch info into this table. In the DM I connect them and now it looks good. 

I tested it also on my real life modell and the performance of the merge is not the best but its okay.

If you have a look and give me some suggestion to improve, that would help me also to improve my knowledge

thanks

batch issue_detailedV2.pbix