Forum Discussion
Total incorrect using 2 different Fact tables
This shows correct Day Values but wrong Total
Variance vs. Fin Fcst $ =
IF ( ISBLANK ( [Actual] ), BLANK (), [Actual] - [Financial Forecast] )
This shows correct Total but wrong days
Variance vs. Fin Fcst $ 2 =
SUMX (
'Calendar',
IF ( ISBLANK ( [Actual] ), BLANK (), [Actual] - [Financial Forecast] )
)
Actual is off this FACT table ‘Daily Sales POS’
Financial Forecast this is off FACT table ‘SalesProj’
I cannot get the total to come out correctly using SUMX because the 2 values are based off of 2 different table tables.
I think adding some logic to check for the total row will help you pull these things together.
Here is a video from Pragmatic Works about this: How to Solve the Total Row with DAX in Power BI Desktop - YouTube
Code:
IF(HASONEVALUE(Calendar[Date]), [Actual] - [Financial Forecast],SUMX('Calendar', [Actual] - [Financial Forecast])
)
4 Replies
I think adding some logic to check for the total row will help you pull these things together.
Here is a video from Pragmatic Works about this: How to Solve the Total Row with DAX in Power BI Desktop - YouTube
Code:
IF(HASONEVALUE(Calendar[Date]), [Actual] - [Financial Forecast],SUMX('Calendar', [Actual] - [Financial Forecast])
)
Hi pokdbz,
Thank you for reaching out to Microsoft Fabric Community.
Thank you d_m_LNK for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue? or let us know if you need any further assistance.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
Hi @pokdbz,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user resolved your issue.
If any response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
