cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II

## 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

 FirstDayofMonth CustID AreaID CityCode HoodID Count 1/1/21 11111 1 200 100 10 1/1/21 22222 1 200 100 20 1/1/21 33333 1 200 100 30 1/1/21 77777 2 400 10 100 1/1/21 66666 2 400 10 200 2/1/21 11111 1 200 100 1000 2/1/21 22222 1 200 100 2000 2/1/21 33333 1 200 100 3000 2/1/21 77777 2 400 10 10,000 2/1/21 66666 2 400 10 20,000

This is the result:

 FirstDayofMonth HoodID Count 1/1/21 100 60 1/1/21 10 300 2/1/21 100 6,000 2/1/21 10 30,000

Thanks All !

1 ACCEPTED SOLUTION
Super User

@dolevh  you can simply use this measure

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

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

3 REPLIES 3
Super User

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 (
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

@dolevh  you can simply use this measure

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

Proud to be a Super User!

New Animated Dashboard: Sales Calendar

Super User

Hi,

This shoudl do what you want:

Table 2 = SUMMARIZE('Summarize (2)','Summarize (2)'[FirstDayofMonth ],'Summarize (2)'[ HoodID],"Count",SUM('Summarize (2)'[ Count]))

I hope this helps and if it does consider accepting this as a solution!

Proud to be a Super User!