- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculate the number of Documents that have fewer than 12 product units in total
Good morning
I ask for their help to solve my problem. I have the following table:
I want to calculate how many Documents have "Qty" less than 12 units regardless of the "products". Yes, I use
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
Assuming Qty is a measure you have written, write this measure
Measure = countrows(filter(values(Data[Documents]),[Qty]>12))
Hope this helps.
Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks but it doesn't work
The solution I found for now was to group the columan in power query, with that I have the document number, the amount and the date that serves me for the measurements I need to create
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

please share the dummy data pbix file for easy reference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Try this Measure
Documents with Qty < 12 =
CALCULATE (
DISTINCTCOUNT ( YourTable[Document_ID] ),
FILTER (
YourTable,
YourTable[Qty] < 12
)
)
If it helps Please Kudos to work and Accept it as Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks but it doesn't work because for the filter it takes the amount related to the product, I must first have a measure that gives me the total per document and then filter that measure

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-31-2024 12:51 PM | |||
07-23-2024 01:29 PM | |||
04-15-2024 01:14 PM | |||
06-04-2024 03:05 AM | |||
07-18-2023 12:10 AM |
User | Count |
---|---|
132 | |
105 | |
85 | |
55 | |
46 |