Forum Discussion

csandwick's avatar
csandwick
Frequent Visitor
8 years ago

Using total from rows and not totaling the columns

In my report my measure column is showing the correct number for each row, but the total at the bottom is wrong. The measure takes the stanard weight times the quantity. The formula for the measure i...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

csandwick,

Create the following measure in your table.

Measure2 = SUMX('BelleHarvest Inc$Item Ledger Entry','BelleHarvest Inc$Item Ledger Entry'[Quantity]* 'BelleHarvest Inc$Item Ledger Entry'[Standard Weight])



Regards,
Lydia

csandwick's avatar
csandwick
Frequent Visitor
8 years ago

The information is coming from two different direct quries, the Item Ledger and Item Variant table so BI wont accept that formula for the measure.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    csandwick,

    It seems that you refer to different columns and tables, could you please share dummy data of your tables and post error message you get?

    Regards,
    Lydia