06-20-2018 02:29 PM
How to take results of this IF statement :
FACILITIES = IF(DISTINCTCOUNT(Inventory_Snapshot[FACILITY])>1,"Multiple","Single")
to this: count(CATALOG_ID) for If statement results
CATALOG_ID not present on visual
06-21-2018 06:33 AM
@Thejeswar yeah not sure if i want that, since I Start with big table of inventory, wanna now which parts are available in multiple facilities, and then whats the overall of parts in multiple vs single facilities. So its easy to create If statement using DAX checking which part is present in multiple vs single facielietes, but then to take that result and calulte the rest is hard.