Forum Discussion

szablock's avatar
szablock
Helper I
9 years ago
Solved

DAX calculation

I sturugle with Dax problem I have data model which looks like that The third measure is result of calculation Measure 2/ Measure 1 What I'd like to do is sum of all result for one month whic...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    szablock

     

    In your formula, the ALLEXCEPT() will have your calculation group on month so that it will return incorrect result. For your requirement, you just need to multiple those two column and use SUMX() without any filter.

     

    Measure 6 = SUMX(Table3,Table3[Hired]*Table3[Fired])

     

     

    Regards,

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

szablock

 

 

 

M3 = DIVIDE(Sum(Table2[M1]),sum(Table2[M2]))

Replace sum(m1) , sum(m2) with your measure

 

 

M4 = Sumx(ALLEXCEPT(Table2,Table2[F]),[M3])

M4 give answer to your question.

 

 

 

szablock's avatar
szablock
Helper I
9 years ago

M 3M 4

Unfortunatlly is not working the Card Report dosen't dispaly data

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    szablock

     

    What is the error message showed?

    • szablock's avatar
      szablock
      Helper I
      9 years ago

      Ok at the moment it replace some value but It not react on Hierarhy Slicer I mean If I add this to table It shows all records even when I select one on slicer

    • szablock's avatar
      szablock
      Helper I
      9 years ago

      With M3Without M3

      • szablock's avatar
        szablock
        Helper I
        9 years ago

        I a bit simplyfy the model right now I have two columns

        hired , fired   and thirdth which is

        Mesure 2 = hired * fired

         

        What I would like to do is pass the sum of multiply to card so in my case that would be 903

         

        Measure 2 = CALCULATE(   sum(Fact_HR_KPI4[fired]) * SUM(Fact_HR_KPI4[hired]))

         

        and Measure 3 = SUMX(ALLEXCEPT(Fact_HR_KPI4;Fact_HR_KPI4[month_period]);[Measure 2])

        which I use for card