DAX IF statement (category not on visualization)

[Maciek]

Hey All,

How to take results of this IF statement :

FACILITIES = IF(DISTINCTCOUNT(Inventory_Snapshot[FACILITY])>1,"Multiple","Single")

Results:

CATALOG_ID	FACILITIES
2	Single
3	Single
4	Single
5	Single
282567	Multiple
1179700	Multiple
1316871	Multiple
1360016	Multiple

to this: count(CATALOG_ID) for If statement results 

CATALOG_ID not present on visual

Result:

Multiple 4

Single 4

Thanks,

Maciek

[Thejeswar]

@Maciek,

Building a Table visualization With Facilities and Count of Catalog ID would solve this.

(iF that is what you want...)

[Maciek]

@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.