Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |