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

Anonymous's avatar
Anonymous
Not applicable
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