Forum Discussion

shashar11's avatar
shashar11
Frequent Visitor
6 years ago
Solved

Suggestion needed

Hello -   I need suggestions for building a PBI visual. Please see the below sample data:   Employee ID Sold Items Price 1 Fruits 10 1 Flowers 5 1 Vegetable 15 2 Flowers ...
Show and Tell
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi shashar11 ,

     

    Here we go.

     

    Measure = 
VAR m =
    CALCULATE (
        MAX ( 'Table'[Price] ),
        ALLEXCEPT ( 'Table', 'Table'[Employee ID] )
    )
RETURN
    IF ( MAX ( 'Table'[Price] ) = m, 1, BLANK () )

     

    Pbix as attached.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi shashar11 ,

 

Here we go.

 

Measure = 
VAR m =
    CALCULATE (
        MAX ( 'Table'[Price] ),
        ALLEXCEPT ( 'Table', 'Table'[Employee ID] )
    )
RETURN
    IF ( MAX ( 'Table'[Price] ) = m, 1, BLANK () )

 

Pbix as attached.

 

shashar11's avatar
shashar11
Frequent Visitor
6 years ago

Thank you so much! I appreciate your help on this.