Forum Discussion

fbittencourt's avatar
fbittencourt
Icon for Helper IV rankHelper IV
1 year ago
Solved

Jon two mesures in one

Hi friends!!

 

Simple case :

 

I have to join 2 mesures  in one

 

 

Surplan 15 = CALCULATE(SUM(FAIT_INDICATEURS[Disponibilité Restante]),FILTER('FAIT_INDICATEURS', FAIT_INDICATEURS[Disponibilité Restante]>0))
 
I need to apply a dynamic filter that i have created for month , month +1

DispoM+1 = CALCULATE(SUM(FAIT_INDICATEURS[Disponibilité Restante]), FAIT_INDICATEURS[MOIS] = FORMAT(EDATE((TODAY()), 1), "YYYYmm"))
 Tks all!!
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    fbittencourt , Try using

    DAX
    CombinedMeasure =
    VAR CurrentMonth = FORMAT(TODAY(), "YYYYMM")
    VAR NextMonth = FORMAT(EDATE(TODAY(), 1), "YYYYMM")
    RETURN
    CALCULATE(
    SUM(FAIT_INDICATEURS[Disponibilité Restante]),
    FILTER(
    FAIT_INDICATEURS,
    FAIT_INDICATEURS[Disponibilité Restante] > 0 &&
    (FAIT_INDICATEURS[MOIS] = CurrentMonth || FAIT_INDICATEURS[MOIS] = NextMonth)
    )
    )

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Icon for Super User rankSuper User
    1 year ago

    fbittencourt , Try using

    DAX
    CombinedMeasure =
    VAR CurrentMonth = FORMAT(TODAY(), "YYYYMM")
    VAR NextMonth = FORMAT(EDATE(TODAY(), 1), "YYYYMM")
    RETURN
    CALCULATE(
    SUM(FAIT_INDICATEURS[Disponibilité Restante]),
    FILTER(
    FAIT_INDICATEURS,
    FAIT_INDICATEURS[Disponibilité Restante] > 0 &&
    (FAIT_INDICATEURS[MOIS] = CurrentMonth || FAIT_INDICATEURS[MOIS] = NextMonth)
    )
    )