Forum Discussion

gatesmetbus's avatar
gatesmetbus
Frequent Visitor
3 years ago

Powerbi Subtotal Showing wrong amount!! HELP

 
For some reason, 2 separate rows aren't included in the calculation of POWERBI emplores subtotals. Please note the amount shows up for the 2 rows but isn't included in the calculation. 
 
Actuals Sum = SUM(_Transactions2[Net Amount]) here is my dax to obtain those values.
 sample of transactions table 
 
tax fundaccount dateNEt amount EB
8542111002/20/225050
8552115502/5/226060
     

 

sample of layout

 

Level 1levl 2lev3 PKL1OrderL2orderl3orderCalculation
operating income rental incomerental income101101101101SUM
operating expense Operating & MaintenanceSmall Tools Expense149110133149Sum
operating expense Taxes and InsuranceProperty  & Liability Ins156110155156sum
        

 

 

sample visual data straight from powerbi table export so you can see also.

 

 

should be calculation

 

 

powerbi calculation

 

Rubbish Removal116,960TRUE116,960
Security Contract103,975TRUE103,975
Small Tools Expense3,865TRUE3,865
Snow Removal Contract6,184TRUE6,184
Window Expense2,494TRUE2,494
 233478FALSE229613
data protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    3 years ago

    could you pls provide the sample data and the expected output?

    now i can't figure out the relationship between the tables you provided.