DAX calculation

[szablock]

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)

[szablock]

table which explain my problem

Slawek

[Vvelarde]

@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]

M 3M 4

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

[Vvelarde]

@szablock

What is the error message showed?

[szablock]

With M3Without M3

[szablock]

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 · Accepted solution]

@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]

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

[szablock]

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