Forum Discussion

anacpint's avatar
anacpint
Icon for Helper I rankHelper 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

Can you show me what the formule is that you have made?

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

I already tried a lot of differents but one of them was: SUMX(GROUPBY(FactOTDJnJPap, FactOTDJnJPap[IDTypeReportJnJPharma], FactOTDJnJPap[IDSiteJnJPharma]),IF([COUNTReport]=2,

CALCULATE(DIVIDE(SUM(FactOTDJnJPap[measurevalue]),2)), SUM(FactOTDJnJPap[measurevalue])).
What I'm trying to do is: check the distinct Type of reports, if they are 2 then divide the sum of the measure by two, if 1 just sum the measure value, considering just two types of report (CPV and PQR). In the total value I need to see the sum of that calculations, just for CPV and PQR.