Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
6 years ago
Solved

wrong total sum

Why total sum is wrong?  
Need Help
  • Analitika's avatar
    Analitika
    6 years ago

    Solved.

    NewMeasure=
    SUMX(VALUES(PercentTable[CODE]),[4thcolMeasure])

     

Analitika's avatar
Analitika
Post Prodigy
6 years ago

Measure for 4th ( wrong) column
Col1-Col2*DinamicPercent

DinamicPercent =
IF(MAX(PercentTable[%])=0,[SomeProcentFromMeasure],MAX(PercentTable[%]))

SomeProcentFromMeasure =
Var Period1 = 
CALCULATE (
[s],
DATESINPERIOD ( 'Date'[Date], LASTDATE ( 'Date'[Date] ), -12, MONTH ),
ALL(Table1),
ALL(Table2),

ALL(Table3)
)

Var Period2 = 
CALCULATE (
[z],
DATESINPERIOD ( 'Date'[Date], LASTDATE ( 'Date'[Date] ), -12, MONTH ),
ALL(Table1),
ALL(Table2),

ALL(Table3)
)
Return
DIVIDE(Period1,Period2)

 

 

PercentTable
Code | %
Code1 | 0%
Code2 | 5%
Code3 | 5%

vanessafvg's avatar
vanessafvg
Community Champion
6 years ago
thanks thats helpful but i can't see the header columns on your screen shot, what is the calculation for [s] and [z]
  • Analitika's avatar
    Analitika
    Post Prodigy
    6 years ago

    It is to complex for s and z calculation, so say it Deb - cred from Table10

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      6 years ago
      you need to provide all the calculations, can't see what the problem is without understanding what you are doing.
      • Analitika's avatar
        Analitika
        Post Prodigy
        6 years ago

        should i post all 100 tables and 200 measures?