Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a data set of material consumption. The table has both which material is consumed aka "Material" and where it is consumed "Order".
For modeling Material is made the key field. However for one specific purpose I.e. showing consumption chart of material, need to sum Quantities by Order and not material field.
Pls note in most pages of my report, slicer of Material exist, hence I am finding it very difficult to sum quantities by Order.
Anyhelp would be appreciated.
Let me repharase the situation of my model a bit. I have this matrix situation and slicer is set for product/ material, so it is filtering what materials are used for production of each product. i need to change filter context for one visual so it shows me products to product consumption.
@Shanze, It appears you should use measure with ALL. this would ignore defined filters - in your case material filter..
https://learn.microsoft.com/en-us/dax/all-function-dax
I did, but then it doesn't sum up quantities at all.
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |