Forum Discussion
Help with optimizing DAX measure - Income statement
Hi,
I found my way around it. My problem seems that when i expanded a row a lot of the G L Accounts were being re-calculated multiple times, for instance Revenue accounts goes into revenue, gross profit, EBITDA and EBIT but using INSCOPE allowed me to not allow any hierarchy beneath the categories i defined in my code and so they are being calculated at a top level but not again when i expand a row
We'll need more info before we can offer any suggestions. Ideally you could share a PBIX uploaded to Google Drive, OneDrive etc, but if you can't share that due to data sensitivity I think we'd need a diagram view showing all the tables involved in the calculation and the relationships between them, which fields you have in your matrix and which tables those come from, and finally we'd need the definition of [ACT LY] and any measures that depends on.
Hi,
I found my way around it. My problem seems that when i expanded a row a lot of the G L Accounts were being re-calculated multiple times, for instance Revenue accounts goes into revenue, gross profit, EBITDA and EBIT but using INSCOPE allowed me to not allow any hierarchy beneath the categories i defined in my code and so they are being calculated at a top level but not again when i expand a row