Forum Discussion

DanielKunc's avatar
DanielKunc
Frequent Visitor
6 years ago

Measure in Total Row

Hi, I'm creating report with Table where are several measures but Total Row shows incorrect numbers ( Measure result ) I'm using this measure:   Still to be invoiced ACY = IF( [Invoiced Line Amo...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

DanielKunc , Row context issue. Try like

Sumx(summarize(Table, table[parent_project_id], "_1",[Still to be invoiced ACY]),[_1])

  • DanielKunc's avatar
    DanielKunc
    Frequent Visitor
    6 years ago

    amitchandak Thank You for your promt reply but it unfortunately doesn't work.

    Parent Project ID is from [Projects], "sublevel" is from [Contracts detail]. Each measure used in this PivotTable is in [Contracts detail] and they are similar to each other, for example:

    Line Amount excl. VAT ACY = SUMX('Contracts Detail';'Contracts Detail'[Line Amount Excl. VAT (REP) after Discount])

    They work fine on row and total level. But Still to be invoiced ACY does not work on Total level.

    Thank You