Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Building a Table visualization With Facilities and Count of Catalog ID would solve this.
(iF that is what you want...)
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |