Forum Discussion

levialae's avatar
levialae
Frequent Visitor
5 years ago
Solved

Measure with two different columns

Hi   I am trying to calculate how the energy use per ton of production. The energy use per day is in a different table than the production per day. When I try to use the related function it get th...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    levialae 

    Yes, that's kind of sample data. However, you can simplify that and not the screenshot. It's very hard for us to create the solution based on the screenshot. You can just paste some data in the reply. At last, pls let us know what the result you want to get based on the data you provided.

    i just created some simple data and provide a solution. pls see the attachment and check if this is what you want.

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey levialae ,

 

can you show the relationship?

Otherwise you should also be able to calculate that with the CALCULATE function and some modification of the filter context. What exactly do you need?

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
levialae's avatar
levialae
Frequent Visitor
5 years ago

Hi Denis

 

I have attached a screenshot of the relationship.

The relationship is between the two 'daily' columns. I have also tried the two 'DateTime' columns which I didn't change anything for me.

 

So what I need is:

The oil use daily divided by the daily tons produced (kiln 1 scale). This will give me how much oil did we use per ton of production. 

 

 

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    levialae 

    The relationship is many to many. You need to clean up the data and make it to be one to many or many to one.

    • levialae's avatar
      levialae
      Frequent Visitor
      5 years ago

      Hi again Ryan

       

      It might be a stupid question, but how would I go about cleaning up date data? 

       

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        5 years ago

        levialae 

        I think you need to check

        1. if there is any blank value for FQN

        2. what's the reason caused many to many relationship? Is it correct that you can have values that does not exists in the other table?

        at last i think you need a DIM table

        Table 2 = DISTINCT(UNION(DISTINCT('Table'[FQN]),DISTINCT('Table (2)'[FQN])))
        use this table and create one to many relationships with the current two tables.