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
v-zhenbw-msft's avatar
v-zhenbw-msft
Community Support
6 years ago

Hi DanielKunc ,

 

Maybe the condition of IF function is wrong, you can try measure like this,

 

New Measure = 
IF([Invoiced Line Amount ACY Remaining]=0,[Invoiced Line Amount ACY Remaining],[Line amount excl. VAT ACY]-[GL_Amount])

 

The result like this,

 

 

If it doesn’t meet your requirement, could you please provide a mockup sample  based on fake data or describe the fields of each tables and the relations between tables simply?

 

It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to OneDrive For Business and share the link here.

 

Please don't contain any Confidential Information or Real data in your reply.

 

BTW, pbix as attached.

 

Best regards,

 

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • DanielKunc's avatar
    DanielKunc
    Frequent Visitor
    6 years ago

    Hi v-zhenbw-msft ,

    sorry for late reply and thank you for your reply.

    I've prepared PBIX file where are simplified columns (I'm using Measures with the same Measure names). The issue is with Grand Total of the Still to be invoiced ACY measure:

     

    Still to be invoiced ACY = 
VAR LineAmountGL = ([Line amount ACY] - [GL_Amount])
VAR DivideLineAmountGL = ABS(DIVIDE([Line amount ACY],[GL_Amount])-1)
RETURN
IF(DivideLineAmountGL>0.02,[Invoiced Line Amount ACY Remaining],
IF([Invoiced Line Amount ACY] = 0, LineAmountGL,[Invoiced Line Amount ACY Remaining]))

     

    The Grand total shows values based on this "formula"

    And I would need to get sum of each row of this "formula" as it's in Excel Pivot table. 

     

    Thank You very much

    DAniel