Forum Discussion

yanivvl's avatar
yanivvl
Frequent Visitor
8 years ago
Solved

Why DATESYTD with another filter do not work inside CALCULATE ?

hi , i have a model like that:   and i have a mesure in Buildings like that :   bl_Ytd_YhdCrntStg = CALCULATE( SUM( Dim_Buildings[HousingUnits] ) ,Dim_BuildingConstructionProgress,Dim_Buil...
  • yanivvl's avatar
    yanivvl
    8 years ago

    THANKS Lydia - BIG HELP !!!

    TO QOMMUNTY HERE IS THE SOLUTION BY LYDIA :

     

    Measure 1 = CALCULATE(CALCULATE( SUM( Dim_Buildings[HousingUnits] ) , DATESYTD( Dim_Time_BldCnstPrgrs[DT_Date])),Dim_BuildingConstructionProgress[is_current]=1 )

     OR

    Measure 2 = CALCULATE( TOTALYTD(SUM(Dim_Buildings[HousingUnits]),Dim_Time_BldCnstPrgrs[DT_Date]),Dim_BuildingConstructionProgress[is_current]=1)

     :manhappy:

yanivvl's avatar
yanivvl
Frequent Visitor
8 years ago

hi , here is the relationship  :

               

   i will be glad to add samPle of data or pbix file but i dont knwo how to do it , there is no attach file option here ..

and yes , i get the expected results even with other time function.  THANKS!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

yanivvl，

You can upload PBIX file to OneDrive, and share me the shared link of the PBIX file via Private Message.

Regards,
Lydia

  • yanivvl's avatar
    yanivvl
    Frequent Visitor
    8 years ago

    THANKS Lydia - BIG HELP !!!

    TO QOMMUNTY HERE IS THE SOLUTION BY LYDIA :

     

    Measure 1 = CALCULATE(CALCULATE( SUM( Dim_Buildings[HousingUnits] ) , DATESYTD( Dim_Time_BldCnstPrgrs[DT_Date])),Dim_BuildingConstructionProgress[is_current]=1 )

     OR

    Measure 2 = CALCULATE( TOTALYTD(SUM(Dim_Buildings[HousingUnits]),Dim_Time_BldCnstPrgrs[DT_Date]),Dim_BuildingConstructionProgress[is_current]=1)

     :manhappy: