Forum Discussion

nicoenz's avatar
nicoenz
Helper III
2 years ago
Solved

How can i sum this data without the overlapping values

hi everyone, I want to create a simple sum function that allows me to select the Version (with a slicer) and sums the forecasted and the actual "Contr_Margin values" excluding overlaps. I have the ...
Need Help
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

you are welcome

  • nicoenz's avatar
    nicoenz
    Helper III
    2 years ago

    it works perfectly well the way you have it.

    i tried integrating everything into a single measure and i get the wrong column total. any idea why?
    i defined:

    Measure 2 =     

    var actual2 = CALCULATE(sum('Table (2)'[Contr_Margin]),'Table (2)'[Versions]="Actual")

    var fc = CALCULATE(sum('Table (2)'[Contr_Margin]),'Table (2)'[Versions]="Fcst May")

    var measure = if(ISBLANK([actual2]),[fc],[actual2])

    return

    sumx(values('Table (2)'[Fact_Date]),[Measure])

    Can all be integrated into a single measure?

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      2 years ago

      have to separate the measures. That will not work if you combine two measures.