Forum Discussion

dolevh's avatar
dolevh
Icon for Helper II rankHelper II
4 years ago
Solved

Sum Measure with Filter

Hi,  I'm looking for Dax that show me the Total Count if (FirstDayofMonth = FirstDayofMonth and AreaID = AreaID and CityCode = CityCode and HoodID = HoodID).   My name of this table is: NadRe   ...
Need Help DAX
  • smpa01's avatar
    smpa01
    4 years ago

    dolevh  you can simply use this measure

    Measure =
CALCULATE (
    SUM ( 'Table'[Count] ),
    ALLEXCEPT ( 'Table', 'Table'[FirstDayofMonth], 'Table'[HoodID] )
)

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new table, and it uses SUMMARIZECOLUMNS function.

 

 

Result Table =
SUMMARIZECOLUMNS (
NadRe[FirstDayofMonth],
NadRe[HoodID],
"Count", SUM ( NadRe[Count] )
)