Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Find matching values within same column with calculated measure and condition

Hi,   I am trying to find and match identical values within same column based on a calcualted measure and condition.   I tried two formulas:   Match = VAR R1 = FILTER(DISTINCT(targetbillboar...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    Try this as VAR R1

     

    VAR R1 =
CALCULATETABLE (
    VALUES ( targetbillboard_enroute_master_table[deviceid] ),
    FILTER ( ALL ( targetbillboard_enroute_master_table ), [RANK_] = 1 )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous 

 

Try this as VAR R1

 

VAR R1 =
CALCULATETABLE (
    VALUES ( targetbillboard_enroute_master_table[deviceid] ),
    FILTER ( ALL ( targetbillboard_enroute_master_table ), [RANK_] = 1 )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

Zubair_Muhammad  Thanks for replying with a solution. This works. Amazing.

 

Regards,

Waqas