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,

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,
Lydia

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: