Sum of count for 24 months

[Anonymous]

Hello,

I need  help to solve the problem I am facing.

I have a slicer with year. When  I select two year the a time, I want to see the sum of count of Movement Type for same Material.

Example, For Material -100000, count of Movement Type is 2 for the year 2017 and count of Movement Type is 4 for the year 2018, While I select both 2017 & 2018 from the slicer I want to see the sum of count of Movement Type  2 & 4 for the Material -100000.

Can anyone help me with this?

[VahidDM]

Hi @Anonymous 

If year and Material are from same table and there is no other filter, then Try this:

Measure = count(table[Material])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

[Anonymous]

Hi @VahidDM , I need to do sum of count of Movement Type for two years when I select them from slicer

[v-easonf-msft]

Hi, @Anonymous 

Replace you field 'count of movement type' with a new measure as below:

Measure = CALCULATE(COUNT('Table'[MovementType]),FILTER('Table','Table'[Year] in VALUES('Table 2'[Year])))

If it doesn't meet you requirement ,please share your sample file or relevant screenshot.

Best Regards,
Community Support Team _ Eason

[VahidDM]

Is that "count of Movement Type"  a measure or a column?