Forum Discussion
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_BuildingConstructionProgress[is_current]=1 , DATESYTD( Dim_Time_BldCnstPrgrs[DT_Date]) )
as you can see i am trying to sum HousingUnits and to use 2 filters : is_current=1 ; DATESYTD .
the problem is that DATESYTD do not work when its with is_current=1 , And also not in the opposite direction ,
can anybody tell me why ? THANKS!
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:
4 Replies
yanivvl,
What fields do you use to create relationship among the above three tables? Would you please share sample data of the three tables?
In addition, do you get expected result when you use existing fields inn the three tables to create visual?
Regards,
Lydiahi , 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!
yanivvl，
You can upload PBIX file to OneDrive, and share me the shared link of the PBIX file via Private Message.
Regards,
Lydia
