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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.