Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jguy
Frequent Visitor

Item Attribute Differences

My problem:

I work for a company that sells stuff denoted by item numbers. I have these item numbers in a table. These item numbers also have various attributes assigned to them. We have several different sub companies that have the same item number and attributes. I'm trying to find a way to find any item attribute that does not match the others by sub company so we can do data clean up. Please see an example item:

 

ITEMNMBRITMCLSCDCompanyBrandATTRIBUTE_AATTRIBUTE_CATTRIBUTE_DATTRIBUTE_EATTRIBUTE_FATTRIBUTE_GMaterial
BTA4610BTA IMPBHIBIOPremiumShallow Conical HexTapered ProLaser LokMountfreeHuman use implant (sterile)Titanium alloy
BTA4610BTA IMPCHILEBIOPremiumShallow Conical HexTapered ProLaser LokMountfreeHuman use implant (sterile)Titanium alloy
BTA4610BTA IMPITA16BIOPremiumShallow Conical HexTapered ProLaser LokMountfreeHuman use implant (sterile)Titanium alloy
BTA4610BTA IMPGERMBIOPremiumShallow Conical HexTapered ProLaser LokMountfreeHuman use implant (sterile)Titanium alloy
BTA4610BTA IMPUKINGBIOPremiumConical HexTapered ProLaser LokMountfreeHuman use implant (sterile)Titanium alloy
BTA4610BTA IMPCANBIOPremiumShallow Conical HexTapered ProLaser LokMountfreeHuman use implant (sterile)Titanium alloy
BTA4610BTA IMPIBERBIOPremiumShallow Conical HexTapered ProLaser LokMountfreeHuman use implant (sterile)Titanium alloy
 

 

The different attribute denotation is bolded and italicized.

 

I'm trying to make a flag or filter that picks these item attributes out.

 

My boss uses Access and can do this fairly easily using queries and pivot tables in excel. How can I do this in Power BI?

1 REPLY 1
v-xulin-mstf
Community Support
Community Support

Hi @jguy

 

Try measure as:

Measure = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        ALL('Table'),
        'Table'[ATTRIBUTE_A]=MAX('Table'[ATTRIBUTE_A]) &&
        'Table'[ATTRIBUTE_C]=MAX('Table'[ATTRIBUTE_C]) &&
        'Table'[ATTRIBUTE_D]==MAX('Table'[ATTRIBUTE_D]) &&
        'Table'[ATTRIBUTE_E]=MAX('Table'[ATTRIBUTE_E]) &&
        'Table'[ATTRIBUTE_F]=MAX('Table'[ATTRIBUTE_F]) &&
        'Table'[ATTRIBUTE_G]=MAX('Table'[ATTRIBUTE_G]) 
    )
)

Here is the output:

v-xulin-mstf_0-1619773116232.png

The pbix file is attached.

 

Best Regards,
Link

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.