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.
Hi All,
I need to show Distribution and OOS of products in 2 different tables.
Blank, Pending delivery and shelf replenished are OOS Reasons which I have added to matrix column value.
These are the 2 measures that I have created to calculate the Percentage of Distribution and OOS:
Distribution% = divide(Sum('Distribution&OOS'[Distribution]),calculate(COUNTROWS('Distribution&OOS')),0)
OOS% = divide(Sum('Distribution&OOS'[OOS]),calculate(COUNTROWS('Distribution&OOS')),0)
Distribution works fine, but OOS for different categories are not calculated like I expected.
In the second screenshot above, OOS% for Pending delivery comes up as 100% . whereas it should be as per screenshot below.
It should be compared with all the records in the table, not just Pending delivery Products.
total of distribution and OOS for a Product should be 100%.
This is measure that I have created to get the above values which works fine but the denominator doesn't change when I apply slicers/filters.
OOSReason% = divide(Sum('Distribution&OOS'[oos]),calculate(COUNTROWS('Distribution&OOS'),Allexcept('Distribution&OOS','Distribution&OOS'[Product],'Distribution&OOS'[Workweek])),0)
I want this to be dynamic.
Please help me resolve this.
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 |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |