Forum Discussion

Hansolu's avatar
Hansolu
Helper II
1 year ago
Solved

Modelling issue causing measure not properly working

Hi, i try to solve my issue since some time and close to give up. Would be nice if someone could help me.   Issue: I do have a fact table with machine parameter for each cycle (date and time for ...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    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.

  • Hansolu's avatar
    Hansolu
    1 year ago

    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

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

Can you please attache a picture to explain better the problem, list the measures working and not working and expected outcome?? I am on the pbix but I cannot understand where to go

  • Hansolu's avatar
    Hansolu
    Helper II
    1 year ago

    Hi,

    thanks for looking into it.

    I added some more explanation into the file. 

    Basically, as soon as I drop in data from the rawmaterial table, the relationship is not clear and all number go to the level without rawmaterial. I somehow need to narrow down the realtionship so i can include my raw material.

     

    Original data is much bigger, merge in PQ was a try but performance is really bad

     

    New file:

    batch issue_detailed.pbix

     

    • FBergamaschi's avatar
      FBergamaschi
      Super User
      1 year ago

      Thanks to you

       

      Now the point is to give, to each row in the fact machine table, a raw material batch

       

      If you explain in words how that association can be done, I think with a calculated column we can fix this

       

      If this helped, please consider giving kudos and mark as a solution

      me in replies or I'll lose your thread

      consider voting this Power BI idea

      Francesco Bergamaschi

      MBA, M.Eng, M.Econ, Professor of BI

      • Hansolu's avatar
        Hansolu
        Helper II
        1 year ago

        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