Forum Discussion

szablock's avatar
szablock
Helper I
9 years ago
Solved

DAX calculation

a

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

which is sum of elements for one month

At the moment I use simple DAX Divide (sum(Measure1) , sum(mesure2)

  • 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,

9 Replies

    • 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