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

    )

     

d_m_LNK's avatar
d_m_LNK
Icon for Super User rankSuper User
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])

)