Forum Discussion

Maciek's avatar
Maciek
New Member
8 years ago

DAX IF statement (category not on visualization)

Hey All,

 

How to take results of this IF statement :

 

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

 

Results:

CATALOG_IDFACILITIES
2Single
3Single
4Single
5Single
282567Multiple
1179700Multiple
1316871Multiple
1360016Multiple

 

to this: count(CATALOG_ID) for If statement results 

CATALOG_ID not present on visual

 

Result:

Multiple 4

Single 4

 

Thanks,

Maciek

 

Need Help

2 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    8 years ago

    Maciek,

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

    (iF that is what you want...)

     

    • Maciek's avatar
      Maciek
      New Member
      8 years ago

      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.