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 ...
Need Help
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.