Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Divide values in a line chart

Hello,   I have 2 tables and I would want to divide the values per month. Take note that these values are found in the same table but different metrics type.   1st table has the Metric type Depl...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous you should add a date dimension in your mode which you set a relationship with these two tables on the date column, it will be one to many relationships and then on visuals use date from this new dimension.

 

For this new calculation, add a new measure based on your logic

 

New Metric = DIVIDE ( [Metric from Table a], [Metric from table b] )

or 

New Metric = DIVIDE ( SUM ( TableA[ColumnA] ), SUM ( TableB[Column1] ) + SUM ( TableB[Column2] )

 

To add a simple date dimension, check this post

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello, I appreciate your response but the numbers are found in the same table and column. Just different metric type which is filtered in the filter pane. Do you have any other ideas?

    Or if your idea worked, can you explain step-by-step?