Forum Discussion

jguy's avatar
jguy
Frequent Visitor
5 years ago

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?

Need Help

1 Reply

  • v-xulin-mstf's avatar
    v-xulin-mstf
    Community Support
    5 years ago

    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:

    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.