Income Statement - something wrong with the measure calculation?

Question

Hello,&nbsp;I'm having problems with the display of calculations, such as Subtotal = Revenue - Sales.&nbsp;The example PBIX I've posted has a Region dimension:&nbsp;&nbsp; North, South, East West.Maybe you can see something quickly in my layout or calculations, and hopefully you're not pulling hair out like me.&nbsp;&nbsp;&nbsp;&nbsp;btw Thanks for all the posts I've been reading about grouping, filter, sumx, etc...&nbsp;&nbsp; It's helped me immensely so far.&nbsp;Please let me know your suggestions.&nbsp;PBIX attachmenthttps://www.dropbox.com/l/scl/AACurjwJPGnyISn_b-tfEKUjIaWX5KvgT3c&nbsp;Excel attachmenthttps://www.dropbox.com/l/scl/AACL_wHlC87pZ3iIPUuz71CbtEoeRH1WDwQ&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

v-chuncz-msft · Answer

PBIEhand,
&nbsp;
You may take a look at the following post.
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Forum Discussion

Income Statement - something wrong with the measure calculation?

1 Reply

Related content

DAX Calculate IF OR Statement

If Statement Calculated Column Returning Incorrectly

Calculated Column If Statement

OR Statement ?

SQL Statement opcion error