Forum Discussion

pokdbz's avatar
pokdbz
Icon for Helper II rankHelper II
1 year ago
Solved

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 Varian...
  • d_m_LNK's avatar
    d_m_LNK
    1 year ago

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

    )

     

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

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

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

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

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    1 year ago

    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