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:

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: