- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maximo Purchase Order data filters
Hi all,
I can usually find answers to everything on the Google machine, but this has me stumped.
Purchase Orders can contain Line Types of Services, Materials, Items, or a mix of both Materials and Items.
I'm trying to display only the "both Materials and Items" option in my visual. This seems like an easy formula, but I can't visualize how to create it properly?
Table: POLINE
Column: LINETYPE
LINETYPE: SERVICE, MATERIAL, ITEM
Any help/pointers are appreciated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @bhold32078 ,
You could create a measure like the following codes.
Measure =
IF (
"Item" IN VALUES ( POLINE[LINETYPE] )
&& "MATERIAL" IN VALUES ( POLINE[LINETYPE] ),
1,
0
)
Then put it into filter pane of your table visual and make it showing 1.
If this post helps, then please consider Accept it as the solution to help the other members find it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi v-eachen-msft,
This formula includes purchase orders with either MATERIAL or ITEM ordered against them, which is a big list.
I'm looking for a filter that narrow it to purchase orders that have both MATERIALS and ITEMS ordered againsts a single purchase order, which should be a much smaller list.
I appreciate your help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
visual filter in filters pane?
I'm not sure I understand correct your needs
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry, I'd like to use the Visualizations "table" and create a formula to only display purchase orders that contain both a MATERIAL and an ITEM in its PO Lines.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-16-2024 04:09 AM | |||
07-30-2024 09:57 PM | |||
Anonymous
| 01-04-2023 03:45 AM | ||
08-03-2023 11:28 AM | |||
08-19-2024 04:56 AM |
User | Count |
---|---|
125 | |
81 | |
63 | |
54 | |
42 |
User | Count |
---|---|
194 | |
106 | |
90 | |
63 | |
51 |