I am curious as to how one would go about counting a measure with multiple if statements. For example, my code is as follows for the measure:
STATUS = SWITCH( TRUE() ,
[ACTUAL USA] <1 , “OUT OF STOCK:URGENT PRODUCTION”,
[ACTUAL USA] <6, “REVIEW CUSTOMER ORDERS:URGENT PRODUCTION”,
AND ([TOTAL WEEKS OF INVENTORY] <18, [ACTUAL USA]<12), “RISK:URGENT PRODUCTION”,
AND([TOTAL WEEKS OF INVENTORY] <18, [ACTUAL USA]>12)“PRODUCTION”,
AND ([TOTAL WEEKS OF INVENTORY]>18, [ACTUAL USA]>18)“IN STOCK”,
“REVIEW CUSTOMER ORDERS:URGENT PRODUCTION”)
I then drag this measure onto a matrix table where it can dynamically change but assigns a category or [status] to item SKUs.
I want to get a count of how many of each individual result there are. The table I use has customer and item SKU as the identifiers. The results of the STATUS measure are dynamic as they will change depending on how [ACTUAL USA] and [TOTAL WEEKS OF INVENTORY] are filtered.
Is this possible? Basically I want to create a small table that has the calculated segments as categories and then count how many of each segment there are.
If you can point me in the right direction it would be greatly appreciated !
The data itself is not shareable but if I need to clarify or create a sample set please let me know.