Forum Discussion
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...
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,
With M3Without M3
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