topic Re: Total incorrect using 2 different Fact tables in DAX Commands and Tips

Total incorrect using 2 different Fact tables

pokdbz — Wed, 28 May 2025 15:24:16 GMT

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.

Re: Total incorrect using 2 different Fact tables

d_m_LNK — Wed, 28 May 2025 16:26:15 GMT

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])

)

Re: Total incorrect using 2 different Fact tables

v-achippa — Mon, 02 Jun 2025 15:24:40 GMT

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

Re: Total incorrect using 2 different Fact tables

v-achippa — Thu, 05 Jun 2025 13:13:12 GMT

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

Re: Total incorrect using 2 different Fact tables

v-achippa — Mon, 09 Jun 2025 11:55:17 GMT

Hi @pokdbz,

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