Reply
Highlighted
Frequent Visitor
Posts: 2
Registered: ‎06-20-2018

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

 

Senior Member
Posts: 317
Registered: ‎12-04-2017

Re: DAX IF statement (category not on visualization)

@Maciek,

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

(iF that is what you want...)

 

Frequent Visitor
Posts: 2
Registered: ‎06-20-2018

Re: DAX IF statement (category not on visualization)

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