Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi!
I'm trying to sum the cases where to two values are equal at a lower level of detail. As you can see below, I have a data set containing a category, sub-category, product, status, shipment date column. I have created a column called "Shipped" that is 1 if Status is Shipped and Date of Shipment is not empty (DAX:
The datamodel is relatively simply. Category is top-layer, Sub-Category middle-layer and Orders are the lowest layer. One-to-Many relationship between Category and Sub-Category, and One-to-Many between Sub-Category and Order.
Thanks,
Thomas
Solved! Go to Solution.
I guess you do not need related or additional conditions. I have used your first table as sample and create the following measure:
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
I guess you do not need related or additional conditions. I have used your first table as sample and create the following measure:
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
The problem is not only your ???-measure - you need separate measures, one for the subcategory and one for the category, as they have different mathematical rules.
first measure is count(shipped)=sum (count of order) (crazy, eh?)
second measure actually needs an iterator. For the category you need to list all subcategories, collect their measures, and then add that up.
User | Count |
---|---|
98 | |
91 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |