Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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!!
Hi @VahidDM , I need to do sum of count of Movement Type for two years when I select them from slicer
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
Is that "count of Movement Type" a measure or a column?
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
114 | |
104 | |
101 | |
72 | |
65 |