Reply
bhold32078
Frequent Visitor
Partially syndicated - Outbound

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.

4 REPLIES 4
v-eachen-msft
Community Support
Community Support

Syndicated - Outbound

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.

3-1.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Syndicated - Outbound

Hi 

 

 

 

az38
Community Champion
Community Champion

Syndicated - Outbound

@bhold32078 

visual filter in filters pane?

I'm not sure I understand correct your needs


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)