Forum Discussion

anacpint's avatar
anacpint
Icon for Helper I rankHelper I
4 years ago
Solved

Total value coming from measure is wrong

Hello,   I developed this measure: CALCULATE(if([COUNTReport]=2, DIVIDE(SUM(FactOTDJnJPap[measurevalue]),2), SUM(FactOTDJnJPap[measurevalue])), FactOTDJnJPap[IDTypeReportJnJPharma] IN {1,5}) ...
DAX
DAX Calculation
Total Measure
Total not matching
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi anacpint 
    Pleas try 

    OTD_TESTE =
SUMX (
    SUMMARIZE ( FactOTDJnJPap, DimSite[jnj_site], DimTypeReport[type_of_report] ),
    CALCULATE (
        IF (
            [COUNTReport] = 2,
            DIVIDE ( SUM ( FactOTDJnJPap[measurevalue] ), 2 ),
            SUM ( FactOTDJnJPap[measurevalue] )
        ),
        FactOTDJnJPap[IDTypeReportJnJPharma] IN { 1, 5 }
    )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi anacpint 
Pleas try 

OTD_TESTE =
SUMX (
    SUMMARIZE ( FactOTDJnJPap, DimSite[jnj_site], DimTypeReport[type_of_report] ),
    CALCULATE (
        IF (
            [COUNTReport] = 2,
            DIVIDE ( SUM ( FactOTDJnJPap[measurevalue] ), 2 ),
            SUM ( FactOTDJnJPap[measurevalue] )
        ),
        FactOTDJnJPap[IDTypeReportJnJPharma] IN { 1, 5 }
    )
)
anacpint's avatar
anacpint
Icon for Helper I rankHelper I
4 years ago

tamerj1 It worked!! Thank you very much for your help. You saved my day 😄