Forum Discussion

krish007na's avatar
krish007na
New Member
5 years ago
Solved

Measure Total not correct when created from 2 different tables

I have 2 tables as ProductTarget and Signals. I want to create a measure like ProductTarget[Target] *  Signals[Value]. Some of the ProductTarget[Target] values are 0. So the multiplication will be 0....
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi krish007na ,

    You can create another new measure as below to replace the previous measure [Port wgt avg]:

    Measure = SUMX(GROUPBY('ProductTarget','ProductTarget'[BMName],'ProductTarget'[Desc]),[Port wgt avg])

    Best Regards

Fowmy's avatar
Fowmy
Super User
5 years ago

krish007na 

Please share a sample PBIX file. You can save in Google or One Drive and share the link here.


  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    krish007na 

    Your model needs to be fixed first. You have created Many-to-many relationship and the whole file behaves unexpectedly.
    If Signal is the dimension file, remove duplicates from the Column "Sedol" and set the relation to One-To-Many.