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,

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

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    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,