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.
I am working with 2 columns in Power Bi. First column is (unique ID) Column and the other is (disposition ) column. The disposition column has 3 categories ( Sold, In warehouse, or In transit )
My current table has multiple records for IDs and sometimes one unique ID may have different dispositions at different dates. E.g Unique ID 123 Sold at 11:35AM Unique ID 123 Sold at 12:35 AM & Unique ID 123 went to warehouse at 1:35 AM
I would like to be able to how many units sold , in warehouse or in transit only once per each serial number
Is there anyone that can help me to come up with a formula to record only once how many unique IDs were sold, in warehouse or in transit
Hi @ahmedabdelsaboo,
Suppose your table structure looks like:
You could create a calculated column using below formula:
Total Sales = CALCULATE ( DISTINCTCOUNT ( 'Product Table'[ID] ), ALLEXCEPT ( 'Product Table', 'Product Table'[disposition] ) )
Or, you can create a measure using this formula:
Total Sales measure = DISTINCTCOUNT('Product Table'[ID])
Use a table visual to display data, both above methods can return this result:
Alternatively, you can directly use a matrix to show above results.
Best regards,
Yuliana Gu
Thanks a lot for your help
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |