Forum Discussion

anacpint's avatar
anacpint
Helper I
4 years ago
Solved

Problem with total value

Hello, I have the following measure: OTD_TESTE = IF([COUNTReport]=2, CALCULATE(DIVIDE(SUM(FactOTDJnJPap[measurevalue]),2)), SUM(FactOTDJnJPap[measurevalue]))   COUNTReport = CALCULATE(DISTINCT...
  • anacpint's avatar
    anacpint
    4 years ago

    Thank you for your answer.

     

    This was the solution for the problem:

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

     

    Best Regards, Ana.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Perhaps this works

 

Measure =

SUMX (

    GROUPBY ( 'Table', 'Table'[level1field], 'Table'[level2field] ),

    [Original measure]

)

anacpint's avatar
anacpint
Helper I
4 years ago

Didn't work. The result on the totals are even more different than before.